ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Convert date to length of time in months from set date (https://www.excelbanter.com/excel-worksheet-functions/18401-convert-date-length-time-months-set-date.html)

MJUK

Convert date to length of time in months from set date
 
Can anyone guide me as to how I go about converting a date column to a length
of time in months from a specified time?

Any help would be greatly appreciated.

Thanks,
MJ



Bob Phillips

Use DateDif, explained at http://www.cpearson.com/excel/datedif.htm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MJUK" wrote in message
...
Can anyone guide me as to how I go about converting a date column to a

length
of time in months from a specified time?

Any help would be greatly appreciated.

Thanks,
MJ






All times are GMT +1. The time now is 03:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com