ExcelBanter - date in the future

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - date in the future (https://www.excelbanter.com/new-users-excel/50492-date-future.html)

Ron

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

JE McGimpsey

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

All times are GMT +1. The time now is 10:07 PM.