number of months from one date to another

**kengaroo** · 04-29-2010, 08:39 AM

Could someone please tell me how to modify this formula to calculate the number of months from one date to another?

=DATEDIF(A1,TODAY(),"m")

Regards Ken

**davesexcel** · 04-29-2010, 08:48 AM

replace today() with an actual date

=DATEDIF(A1,B1,"m")

**kengaroo** · 04-29-2010, 08:56 AM

Yes, thank you. I meant to ask months and days. Is this possible?
Also, am I asking these questions in the right area?
Your help is very appreciated.
Regards Ken

**davesexcel** · 04-29-2010, 09:03 AM

Yes it is in the wrong spot, it should be in worksheet functions

Try This

=DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

**Palmetto** · 04-29-2010, 09:09 AM

replace today() with an actual date

Just curious as to why. The formula will return the correct result when using the TODAY() function.

**davesexcel** · 04-29-2010, 09:13 AM

Did you place today's date in B1?

**Palmetto** · 04-29-2010, 11:28 AM

Yes. The formula works - however, as expected, it returns a result of - 0 month 0 days, but it does not error.

**daddylonglegs** · 04-29-2010, 11:36 AM

Originally Posted by davesexcel

=DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

Of course if the period is over a year and you want to show a result like 15 months 11 days then the first DATEDIF should use 3rd argument of just "m", i.e.

=DATEDIF(A1,B1,"m")&" months "&DATEDIF(A1,B1,"md")&" days"

otherwise you never get greater than 11 months 30 days