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.

Excel’s Networkdays worksheet function does it. However, if you did a typical installation of Excel, without Analysis ToolPak, that function will be missing. That’s not a problem, though; it’s easy to ...

Build on this earlier calendar that highlights weekends to also highlight holidays. This technique relies on the NETWORKDAYS () function, which is available in Excel 2007 and later versions.