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 […]
Functions
Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.
WORKDAY Function
The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user specified values. For example, these values would be
WEEKNUM Function
The WEEKNUM Function in Excel will return the week number for a specific date. This function will return an integer from 1 to 52 representing the corresponding week
ROUNDDOWN Function
The ROUNDDOWN function in Excel returns a number rounded down to a specified number of places.
ROUNDDOWN Function Read More »
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.