Excel FunctionsExcel YEARFRAC Function


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.  


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.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.