» Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
Enter birthday date in cell A1: 01/01/1980
To calculate the number of years from the
date, enter the following formula in cell B1: =YEAR(TODAY())-YEAR(A1)
The result (rounded): 23 Years
For a decimal solution, use the following formula: =DATEDIF(A1,TODAY(),"m")/12
The result: 23.25 Years
To calculate the number of months from
the date, enter the following formula in cell D1: =DATEDIF(A1,TODAY(),"m")
The result: 279 Months
To calculate the number of days from the
date, enter the following formula in cell E1: =DATEDIF(A1,TODAY(),"d")
The result: 8499 Days
Book Store:
Recommended Books:
- The 22 Immutable Laws of Branding
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Microsoft Word Version 2002 Inside Out
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Business Analysis with Microsoft Excel (2nd Edition)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports


passes, I need to send out a reminder to these people that receive the letters. I was thinking that perhaps the best way to do this would be to have the cells automatically change colour. But
as only a basic formula user in excel, whats the best way to do this?