Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel

» Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel

CATEGORY: Excel Date & Time Formulas

VERSIONS: All Microsoft Excel Versions

In order to calculate the time elapsed from a certain date, we will use a birthdate as an example

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

Rate this tip



1	2	3	4	5

RATING: 3.41
VIEWS: 107263

Email Tip

Print Tip

Add to My Tips

As time passes

Dianne wrote on December 31, 1969 18:00 EST

I record the date of when I send a letter. I send several hundred of these letters. Once 30 days
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?

saturday each week

Glen wrote on December 31, 1969 18:00 EST

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 wrote on December 31, 1969 18:00 EST

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 wrote on December 31, 1969 18:00 EST

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 wrote on December 31, 1969 18:00 EST

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 wrote on December 31, 1969 18:00 EST

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.

Sponsors:

Book Store:

VIEW ALL BOOKS

Recommended Books:

Related MS EXCEL TIPS:

Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.