Thread: Running Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Running Time

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

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

On Mar 31, 2:34*pm, Dimitri wrote:
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