About the WEEKDAY () function To highlight weekend dates, we’ll use the WEEKDAY () function in a conditional formatting rule.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.

You can use SUMIF in Google Sheets to add numbers together that are associated with a date range, specific text, or meet a numeric criterion.