Home » Excel » Functions

Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

YEARFRAC Function

YEARFRAC Function

The YEARFRAC function in Excel returns a decimal value that represents fractional years between two specified dates. Syntax: =YEARFRAC(start_date, end_date, [basis]) Arguments: start_date – The start date. end_date …

YEARFRAC Function Read More »

Year Function

YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to pull out the year from a date or …

YEAR Function Read More »

ROUNDDOWN Function

ROUNDDOWN Function

The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.

Scroll to Top