Thread: date in the future

Hi if I have a date in C5 the formula =DATEDIF(C5,TODAY(),"m") gives the
number of months from that date. How can I get the number of months to a
given date in the future from today and if cell E5 contains 08/10/2011?
Thanks Ron

One way:

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

In article <#ujMS#N0FHA.664@tk2msftngp13.phx.gbl>,
"Ron" <ron@flymail.fm> wrote:

> Hi if I have a date in C5 the formula =DATEDIF(C5,TODAY(),"m") gives the
> number of months from that date. How can I get the number of months to a
> given date in the future from today and if cell E5 contains 08/10/2011?
> Thanks Ron