Blog

Tip of the Week: Using a Spreadsheet to Calculate Exact Age

Tip of the Week: Using a Spreadsheet to Calculate Exact Age

Both Microsoft Excel and Google Sheets offer a plethora of features to those who know how to use them, many of them with really niche applications to businesses. For instance, there is one function that allows you to easily calculate the time between the current date and a specified  day that, if applied properly, could easily provide businesses with some serious utility.

Let’s discuss how the =DATEDIF function works, and how it could help you keep track of assorted pieces of data.

What Does =DATEDIF Do?

Using the =DATEDIF function returns the span of time between two different dates. Let’s say that you wanted to figure out how long your employees had each been working for your business.

In either Excel or Sheets, all you have to do is list the start dates that each employee began working for your company, and then in the next column, insert the formula cited below. For clarity we’ll assume that your list of dates starts in cell B2. Therefore, you would type the following formula into C2:

=DATEDIF(B2,TODAY(),”Y”)

This will give you the difference between the provided date in B1, and “TODAY,” the date you’re accessing the sheet, measured in years. You can also replace the “Y” for years with “M” for months or “D” for days. Extending the formula down will give you the results for the rest of your list. For example, this is what it would look like in Google Sheets:

Likewise, it should look something like this in Microsoft Excel:

Be warned, however: this function is somewhat simple to break, so while there are other options, we wouldn’t recommend diving too far into them.

That being said, this trick could potentially be applied to a wide assortment of data, helping you to track the age of projects, time since your last workplace accident…really, it all comes down to what you need to keep track of.

For instance, you could hypothetically use it to track how long it has been since your team had to call White Mountain IT Services for assistance, which is a perk that our managed services clients get to enjoy whenever they need it. Find out more by giving us a call at 603-889-0800.

Related Posts

Wi-Fi connectivity is a remarkable technology when you really think about it, and it has fundamentally changed how we work today. What hasn’t changed, unfortunately, is that hackers and cybercriminals will try to use this technology to their own adva...
A lot of the time, user productivity is just about getting down to business. Sometimes, however, there are simply just too many different tasks to complete and it can bog down the production process. One way that users can use Windows to help them ma...
Most modern organizations will have digitized their businesses to at least some degree without really putting much effort or thought into it. This massive and often unconscious change has created a lot of benefits for businesses with perhaps one of t...
Social media can be remarkably overstimulating, and for some users this is a problem which is difficult to navigate without giving it up entirely. If you want a nice middle-ground to terminating your account entirely, you can instead curate your news...
If you have ever invested time and effort into an Excel spreadsheet, then you know how irritating it is to move all of that data to a different sheet. Thankfully, you can easily and accurately copy this data using a simple technique. Here’s how you c...
One of the big advantages that Mac computers have had over the traditional PC is that they “don’t get viruses,” but how true is this claim, really? Research conducted by Elastic Security Labs proves that this is certainly not the case, discrediting t...
Microsoft Excel is a great tool for keeping data and figures organized…until, that is, you need to scroll down at all, leaving some important headers out of sight. Fortunately, there is a way to keep your headings in view: freezing the panes they are...
All jobs have aspects of them that are simply dull or unengaging. After all, nothing can be exciting all the time. This week we wanted to focus on these rote tasks and what you can do to make them less of an impact on your time and job fulfillment. T...
Have you ever heard of the Uncanny Valley? It’s the theory that explains why the human race tends to prefer humanoid robots, but only up to a point, after which we find them unsettling. It’s one reason why so many people found the 2019 film Cats both...
How often have you been browsing the web on your phone, only to find something that would be legitimately useful for your work—maybe it was a tip you wanted to try out, or a bit of information that would be helpful to know—so you wanted to be able to...
Have you ever found yourself in a position where you wanted to download an email from your inbox? Whether it’s documentation or a different reason, there is a way to download your messages into a PDF. PDFs make for great file-sharing formats, as the ...

The idea of a four-day workweek has been popular for some time now, to the point where it is actively being tested in practical settings. Let’s discuss how successful this approach has been (spoiler alert: it’s been quite successful indeed).

Onsite Service Coverage Area

Although we provide remote services and support to businesses in over 20 states, onsite services are limited to within reasonable driving distance from our offices in NH.  We will manage a local vendor for locations outside of our service area to provide onsite assistance when needed.

 

Onsite Computer Support Services are available to businesses within 60 miles of Nashua New Hampshire. We have excellent onsite coverage from Concord NH, south through Manchester NH, and then down into Boston. From Northern and Central Mass, we cover from Worcester, east to the North Shore, including the Salem NH and Portsmouth NH area.

White Mountain IT Services

 


33 Main St, Suite 302
Nashua, NH 03064

 


121 Riverfront Drive
Manchester, NH 03102

 

Client Help Desk      603-889-2210

New Client Inquiries   603-889-0800

Open Positions