Hi,

DATEDIF function is a useful Excel function in calculating difference between dates; such as getting Age in the following formula:

=DATEDIF(A2;TODAY();"y")&" Year, "&DATEDIF(A2;TODAY();"ym")&" Month, "&DATEDIF(A2;TODAY();"md")&" day"


Name:  DATEDIF.jpg
Views: 6702
Size:  87.4 KB