Thursday, November 14, 2013

EXCEL : Calculate the number of days, months, or years between two dates

6:EXCEL : Calculate the number of days, months, or years between two dates

The DATEDIF function can be used for this.

The syntax for the DATEDIF function is:

= DATEDIF ( start_date , end_date , unit )

• start_date - First or starting date (eg. DATE OF BIRTH)
• end_date - Second or last date (eg. TODAYS DATE)
• unit - Function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates 
Photo: EXCEL : Calculate the number of days, months, or years between two dates The DATEDIF function can be used for this. The syntax for the DATEDIF function is: = DATEDIF ( start_date , end_date , unit ) • start_date - First or starting date (eg. DATE OF BIRTH) • end_date - Second or last date (eg. TODAYS DATE) • unit - Function to find the number of days ("D"), complete months ("M"), or complete years ("Y") between the two dates Try it out.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)