Running Time

[Dimitri]

Hello:

I was hoping that this formula is plausible. In A1 there is a date
14/04/2010, what I am looking for in B1 is a forumla that will tell how many
months are remining from today's date.

A1 B1
01/04/2010 36

Thank you

Dimitri

 

[Pete_UK]

You can use the DATEDIF function, as Chip Pearson describes on his web
site here:

http://www.cpearson.com/excel/datedif.aspx

DATEDIF is only described in Excel Help for XL 2000, though it is a
native function in all versions.

Hope this helps.

Pete

 

[Max]

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

 

[Cimjet]

Hi Dimitri
Try this =(A1-TODAY())/12 and format cell as "General"
Regards
Cimjet

 

[Cimjet]

Sorry wrong answer
Ignore my post.
Cimjet

 

[David Biddulph]

Are you sure? 12 days in a month? This gives 62 months for the example
quoted, whereas it should presumably be 24 months (and not the 36 quoted by
the OP). DATEDIF seems the appropriate answer.