Which formula should I use to return years and months between two dates.
4/1/05 7/30/25
Which formula should I use to return years and months between two dates.
4/1/05 7/30/25
Re: Years & Months Between Two Dates
I think you'll find what you need right here.
Re: Years & Months Between Two Dates
Assuming
A1 1/04/2005
B1 30/06/2005
Copy the formula below in C1
=DATEDIF(A1,B1,"Y")&" Years, "&DATEDIF(A1,B1,"YM")&" Months"
Biz: D
Don’t have an account yet? Register yourself now and be a part of our community!