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.

I love my digital calendar, but I still keep a paper one, too. Its great for quickly checking out upcoming holiday events, birthdays, and other significant plans without getting overwhelmed by ...

Excel's formidable talents stretch into word processing and even graphics. Here's how to create a calendar, customized just the way you want it.