Calculate remaining # of days between 2 dates

**Potato2009** · 08-13-2009, 01:37 PM

I know I may use Datedif(startdate, enddate,"d") to get # of days between 2 dates, but I have to calculate the exact number of months and then the remaining number of days seperately.

For example, startdate=June 15, 2007 and enddate=August 7, 2009, then Datedif(startdate, enddate, "m")=25, but how to get the remaining # of days which is 23?

Thanks!

**maybelle** · 08-13-2009, 02:07 PM

the same formula but set Interval as "md" - this should give the number of days

(http://www.cpearson.com/excel/datedif.aspx)

**martindwilson** · 08-13-2009, 02:14 PM

if you scroll down in that link you'll see this
=IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym")&" months ")&DATEDIF(A1,B1,"md")&" days"

**Potato2009** · 08-13-2009, 03:01 PM

Thank you!

**arthurbr** · 08-13-2009, 03:21 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save