98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » DATEDIF function

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

Added by Garry on 3rd October 2006

More Excel hints and tips, like:

• Autofit column width – Excel (all versions)
• Concatenating Results of Formulas
• No Zeros