Date question

Z

Ziggy

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

Today() - (6-1-2003) = MONTHS
 
Z

Ziggy

Try this...

A1 = 6/1/2003

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

--
Biff
Microsoft Excel MVP







- Show quoted text -
Click to expand...



Thanks it worked great.

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

But thank you very much.
 
T

T. Valko

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


Try this...

A1 = 6/1/2003

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

--
Biff
Microsoft Excel MVP







- Show quoted text -
Click to expand...



Thanks it worked great.

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

But thank you very much.
 
Top