| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
Oscar wrote:
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 With your maturity date in A1: =DATEDIF(TODAY(),A1,"m") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
try this
Cell A2 has 01/01/2035, then in B2 put this formula =DATEDIF(TODAY(),A2,"M") On Nov 19, 9:19*pm, Oscar wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
Thank you very much
"Glenn" wrote: Oscar wrote: 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 With your maturity date in A1: =DATEDIF(TODAY(),A1,"m") |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
"muddan madhu" wrote: try this Cell A2 has 01/01/2035, then in B2 put this formula =DATEDIF(TODAY(),A2,"M") On Nov 19, 9:19 pm, Oscar wrote: 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 What if I want todays date to count on the first of the month? Example: if I enter a Mat date of 11/01/2036 the formula would calculate 335 months, but if we count the 1 st of the month (Nov 1) the Mat date would be 336 months. Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
Oscar wrote:
"muddan madhu" wrote: try this Cell A2 has 01/01/2035, then in B2 put this formula =DATEDIF(TODAY(),A2,"M") On Nov 19, 9:19 pm, Oscar wrote: 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 What if I want todays date to count on the first of the month? Example: if I enter a Mat date of 11/01/2036 the formula would calculate 335 months, but if we count the 1 st of the month (Nov 1) the Mat date would be 336 months. Thanks =DATEDIF(TODAY()-DAY(TODAY())+1,A2,"M") |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Year into months
How about:
=12*(YEAR(A2)-YEAR(TODAY()))+MONTH(A2)-MONTH(TODAY())+(DAY(A2)DAY (TODAY())) Does this help? On Nov 19, 6:45*pm, Oscar wrote: "muddan madhu" wrote: try this Cell A2 has 01/01/2035, then in B2 put this formula =DATEDIF(TODAY(),A2,"M") On Nov 19, 9:19 pm, Oscar wrote: 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 What if I want todays date to count on the first of the month? Example: if I enter a Mat date of 11/01/2036 the formula would calculate 335 months, but if we count the 1 st of the month (Nov 1) the Mat date would be 336 months. Thanks |
| Reply |
| 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) | |||
Linear Mode
