Year into months

[Oscar]

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

 

[Glenn]

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")

 

[muddan madhu]

try this

Cell A2 has 01/01/2035, then in B2 put this formula

=DATEDIF(TODAY(),A2,"M")

 

[Oscar]

Thank you very much

With your maturity date in A1:

=DATEDIF(TODAY(),A1,"m")

 

[Oscar]

try this

Cell A2 has 01/01/2035, then in B2 put this formula

=DATEDIF(TODAY(),A2,"M")

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

 

[Glenn]

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")

 

[vezerid]

How about:

=12*(YEAR(A2)-YEAR(TODAY()))+MONTH(A2)-MONTH(TODAY())+(DAY(A2)>DAY
(TODAY()))

Does this help?