calculate date differences in years and months
How do I calculate differences in dates in months and years? I can do days,
months, and years, but not a combination. |
Hi Joyce
something like this =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months" with your starting date in A1 and your ending date in B1 Cheers JulieD "Joyce" wrote in message ... How do I calculate differences in dates in months and years? I can do days, months, and years, but not a combination. |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com