EXCEL Tips & Tricks:- Calculate the number of days, months, or years between two dates:

20131112-061101 pm.jpg

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.

20131112-061144 pm.jpg

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s