YEARFRAC Function Excel step by step implementation with example

YEARFRAC Function Excel step by step implementation with example

YEARFRAC

Function helps user to calculate years between two dates. YEARFRAC is an inbuilt Excel function and can be very helpful to calculate fraction between two dates.

Syntax

=YEARFRAC(start_date, end_date, [basis])

Basis

  1. US (NASD) 30/360 this is default
  2. Actual/actual
  3. Actual/360
  4. Actual/365
  5. European 30/360

Example

Output

Next >> List All Name Ranges in Excel using VBA

Leave a Reply

Your email address will not be published.