You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ziggy" wrote in message
...
On Apr 16, 2:44 pm, "T. Valko" wrote:
Try this...

A1 = 6/1/2003

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

--
Biff
Microsoft Excel MVP

"Ziggy" wrote in message

...



Is there a simple formula that will give the difference between two
dates in MONTHS?

Today() - (6-1-2003) = MONTHS- Hide quoted text -

- Show quoted text -



Thanks it worked great.

I ended up using the YEARFRAC though as a better solution for my
needs,

But thank you very much.