Excel Tutorials
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts

YEARFRAC function

Posted on July 4, 2018 by Tomasz Decker

Tutorial Content

  • description:
  • syntax:
  • required arguments:
  • optional arguments:

description:

Returns the year fraction.

 

syntax:

=YEARFRAC( start_date, end_date, [basis] )

 

required arguments:

start_date The start date.
end_date The end date.

 

optional arguments:

[basis] The type of day count basis to use.

Post Views: 59
Posted in functions
200+ Excel Interview Questions
  • English
  • .
  • Polski
  • |
  • About
  • |
  • Contact Us
© 2022 OfficeTuts. All Rights Reserved.
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts