Calculating Number of Months passed between two sets of days

**Cindylu3** · 01-23-2009, 03:19 PM

Hello,
I am stuck. I need to calculate the number of months between two sets of dates: for example

5/08/2008-todays date 1/23/2009=

Please help.

Thanks
Cindy

**solnajeff** · 01-23-2009, 03:29 PM

Hi

For complete months use "Date one minus Date two" and format using Custom format as "MM", providing it is not more than one year.

Regards

Jeff

**Cindylu3** · 01-23-2009, 03:34 PM

In most cases it is more than one year...How would I modify the formula?

**solnajeff** · 01-23-2009, 03:40 PM

Hi

Sorry I should have added

Please Login or Register  to view this content.

If your dates are in the relevant cells.

Regards

Jeff

**Cindylu3** · 01-23-2009, 04:15 PM

That worked out great. But now Im being asked to show "x years, x months, x days". I know, I know this should be really easy to figure out...

**DonkeyOte** · 01-23-2009, 04:29 PM

A1: start
A2: end
A3: =A2-A1
A3 custom format of: y "Years, " m "Months & " d "Days"
(note you may need to add 1 to A3 result if dates are to be seen as inclusive).

EDIT: disregard -- safer to adopt DATEDIF as outlined by arthurbr and prior post... note though that earliest date should be listed first (the below is I suspect the opposite way around for you in reality - ie TODAY() > start date)

**arthurbr** · 01-23-2009, 04:30 PM

Try =DATEDIF(TODAY(),a1,"y")&" years "&DATEDIF(TODAY(),a1,"ym")&" months "&DATEDIF(TODAY(),a1,"md")&" days"

**Cindylu3** · 01-23-2009, 05:04 PM

I still cant get it to work. I have changed the cells to reflect the ones in my spreadsheet. I cant upload my attachment so here is a summary of what i have on my spread sheet:

I4= 05/28/2008 the day the person began at a location
J4= 01/23/2009 todays date
K4= calculated the amount of time in x years, x months, x days (the amount of time the person has been at a location)