Description
Used to return years (in frictions) between two given dates. We can return years by using DATEDIF function as well but DATEDIF returns the year in the whole number, whereas this function returns years in frictions.
=YEARFRAC(start_date,end_date,basis)
The WORKDAY function syntax has the following arguments:
- Start_date Required.
A date that represents the start date.
-
End-Date required
A date that represents the start date.
- Basis Optional.
The type of day count basis to use.
Note: Avoid directly punching dates into the Excel Functions, either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel read the date as ZERO.
