| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Year into months
Hi,
I'm working on a spreadsheet were I enter a maturity date (01/01/2035). On another colum I would like to have a formula were it would convert the maturity date into months. From today to 01/01/2035 it would be 314 months. I want to be able to enter the maturity date as 01/01/2035 format and automaticaly convert that date into months on another column. How can I do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for months and year | Excel Worksheet Functions | |||
| Loading a Combo Box with the months of the year | Excel Discussion (Misc queries) | |||
| Year-Days-Months | Excel Worksheet Functions | |||
| Within 6 months, Within 1 year and so on... | Excel Discussion (Misc queries) | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Threaded Mode
