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.

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.

You’ll use LAMBDA () functions the same way you use Excel functions. To demonstrate, enter the function and reference the values shown in Figure B, =SUBTRACTL (B3,C3).