Excel Date & Time functions tutorial: EDATE, YEARFRAC, EOMONTH, NETWORKDAYS.INTL

Click here to visit Original posting

The Excel Date & Time functions I’m covering here—EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INTL—are four of the many used for counting days. For each function listed below, I’ll define it first, then show the function’s arguments, which are the values that functions use to perform calculations. Then I’ll show a sample of the function’s syntax—how the formula is arranged, which includes the function’s name, parentheses, comma separators, and its arguments.

Note that Arguments are always surrounded by parentheses, and individual arguments are separated by commas.


EDATE is a practical function for returning a date some number of months in the future or past, using a positive value for future dates, a negative value for past dates. For instance, you can use this function to calculate a retirement date or expiration date, to calculate someone’s age from a birthdate, or to add a given number of years to a specified date.

To read this article in full or to leave a comment, please click here