date in the future

[Ron]

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

[JE McGimpsey]

One way:

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

In article <#ujMS#[email protected]>,
"Ron" <[email protected]> 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