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