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 ...
Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times. That piece covered nine Date & Time functions: NETWORKDAYS(), DATEVALUE(), NOW(), DAY(), ...