## Apex Technology Blog
Apex Technology has been serving the Carolinas since 1998, providing IT Support such as technical helpdesk support, computer support and consulting to small and medium-sized businesses.
[ Categories ](https://trustapex.directivesites.com/blog/categories "Categories")
[ Tags ](https://trustapex.directivesites.com/blog/tags "Tags")
[ Categories: All Categories ](https://trustapex.directivesites.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://trustapex.directivesites.com/javascript:void(0);)
# Tip of the Week: Using a Spreadsheet to Calculate Exact Age
[Apex Technology Blog ](https://trustapex.directivesites.com/blog/categories/blog) [Tip of the Week](https://trustapex.directivesites.com/blog/categories/tip-of-the-week)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Wednesday, 08 March 2023
[ 0 Comments ](https://trustapex.directivesites.com/blog/tip-of-the-week-using-a-spreadsheet-to-calculate-exact-age#comments)
[  ](//trustapex.directivesites.com/images/easyblog_shared/March_2023/03-08-23/spreadsheetExcel_242093900_400.jpg "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 Apex Technology 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 (704) 895-0010.
[ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);) [ ](https://trustapex.directivesites.com/javascript:void(0);)
Tags:
[Quick Tips](https://trustapex.directivesites.com/blog/tags/quick-tips) [Software](https://trustapex.directivesites.com/blog/tags/software) [Efficiency](https://trustapex.directivesites.com/blog/tags/efficiency) [Tip of the Week](https://trustapex.directivesites.com/blog/tags/tip-of-the-week)
[ IT Management is Just a Fraction of How We Can Hel... ](https://trustapex.directivesites.com/blog/it-management-is-just-a-fraction-of-how-we-can-help)
[ Not Even Voicemails are Safe from Phishing ](https://trustapex.directivesites.com/blog/not-even-voicemails-are-safe-from-phishing)
About the author
[  ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[Tim Campbell](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ ](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
Tim Campbell is the President of Apex Technology which he founded in 1998. In 2009, Apex launched its Managed IT Services division. Since its inception, Apex has become the premier Managed IT Services Companies in the Charlotte metro area specializing in Managed IT, Security, Data Backup & Cloud Computing Solutions.
Author's recent posts
[More posts from author](https://trustapex.directivesites.com/blog/blogger/tim-campbell)
[ Wednesday, 05 August 2026 5 Essential Steps to a More Secure Wireless Network ](https://trustapex.directivesites.com/blog/5-essential-steps-to-a-more-secure-wireless-network)
[ Monday, 03 August 2026 Building a Business Workspace That Fits In Your Backpack ](https://trustapex.directivesites.com/blog/building-a-business-workspace-that-fits-in-your-backpack)
[ Friday, 31 July 2026 The Power of Modern VoIP ](https://trustapex.directivesites.com/blog/the-power-of-modern-voip)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://trustapex.directivesites.com/component/users/login?return=aHR0cHM6Ly90cnVzdGFwZXguZGlyZWN0aXZlc2l0ZXMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLXVzaW5nLWEtc3ByZWFkc2hlZXQtdG8tY2FsY3VsYXRlLWV4YWN0LWFnZQ==&Itemid=101)
Thursday, 06 August 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**