» Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
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:
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- The Ernst & Young Business Plan Guide
- Microsoft Outlook 2002 for Dummies
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The Financial Numbers Game: Detecting Creative Accounting Practices
saturday each week
Glen
I use an expense report in excel, it is devided into 5 columns titled "saturday week ending". I would like the date of each saturday to appear automaticly when I enter the month to the report.
calculating days
Sandy
I am trying to make a spreadsheet to figure seniority at my workplace. What I would like is to tyoe in a start date and have it calculate how many days worked from todays date.
daisie jackson
I want to write in a start date and have excel post the date after a 180 day period. For example, I want to write in the date 02/24/06 and have the date 08/22/06 posted in the next column.
Date function
chandrashekhar
I am trying date function to find our months diff beteen 2nd april 2006 anf 31 st may 2006 by used DATEDIF function i get result 1 month but the actual months are 2 what could be the useful formula for these type of calculations
calculate a datwe
cinnchameleon
I need a formula to calculate a specific date vx number of days from a given date. For example, the date 100 days from June 1, 2007.
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?