Microsoft Excel's Month and Weekday functions output numeric values for a given date. The Month function results in the month numbers, such as "3" for March or "12" for December. The Weekday ...

To highlight weekend dates, we’ll use the WEEKDAY () function in a conditional formatting rule. This function returns a number between 1 and 7 to identify the day of the week, as a date.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

The Excel WORKDAY function's purpose is to return the serial number of the date before and after a specified number of workdays. Learn how to use it.