Date question

[Ziggy]

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

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

 

[T. Valko]

Try this...

A1 = 6/1/2003

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

 

[Ziggy]

Try this...

A1 = 6/1/2003

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

--
Biff
Microsoft Excel MVP







- 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.

 

[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 -

Thanks it worked great.

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

But thank you very much.