Running Time
 

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

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

Running Time
 

=DATEDIF(TODAY(),A1,"m")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

Running Time
 

Hi Dimitri
Try this =(A1-TODAY())/12 and format cell as "General"
Regards
Cimjet
"Dimitri" wrote in message
...
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

Running Time
 

Sorry wrong answer
Ignore my post.
Cimjet
"Dimitri" wrote in message
...
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

Running Time
 

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.
--
David Biddulph

"Cimjet" wrote in message
...
Hi Dimitri
Try this =(A1-TODAY())/12 and format cell as "General"
Regards
Cimjet
"Dimitri" wrote in message
...
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