View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

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

In article ,
"Ron" 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