| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert running time on excel | New Users to Excel | |||
| running macros at a set time | Excel Discussion (Misc queries) | |||
| keeping a running time for tv program | Excel Worksheet Functions | |||
| Running a macro at a specified time | Excel Discussion (Misc queries) | |||
| Running a macro at a certain time | Excel Discussion (Misc queries) | |||
Linear Mode
