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.
=YEARFRAC(start_date, end_date, [basis])
- US (NASD) 30/360 this is default
- European 30/360
Next >> List All Name Ranges in Excel using VBA