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

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 »



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

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the FLOOR function is set to always round down. …

FLOOR Function Read More »

Scroll to Top