Calculate 'exact' age in EXCEL
Glenn wrote:
If you insist on months, try this:
=IF(B1A1,DATEDIF(A1,B1,"y")&"y, "&DATEDIF(A1,B1,"ym")&"m, "&
IF(DAY(A1)DAY(B1-DAY(B1)),DAY(B1),DAY(B1)+DAY(B1-DAY(B1))-DAY(A1))&"d",NA())
Actually, there is something wrong with this...not sure what and no time to
figure it out right now.
|