ExcelBanter - Cal the different of 2 date (MM,YY)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cal the different of 2 date (MM,YY) (https://www.excelbanter.com/excel-discussion-misc-queries/194711-cal-different-2-date-mm-yy.html)

TSK

Cal the different of 2 date (MM,YY)

Please advised what is formulate to calculate the different in year and month
if A1 is Jan-08 and A2 is Jun-06 and I need the answer to reflect as 1 yr 6
mths

Thank You

Peo Sjoblom

Cal the different of 2 date (MM,YY)

http://www.cpearson.com/excel/datedif.aspx

--

Regards,

Peo Sjoblom

"TSK" wrote in message
...
Please advised what is formulate to calculate the different in year and
month
if A1 is Jan-08 and A2 is Jun-06 and I need the answer to reflect as 1 yr
6
mths

Thank You

All times are GMT +1. The time now is 07:31 AM.