Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel. Weekends and holidays are important to most of us. Besides enjoying the ...

Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a monthly matrix-style calendar. In that article, "Use Excel's conditional formatting to highlight ...

Kumar Malyala asked if there’s a way in Excel to count the number of business days between two dates. However, if you don’t want Saturdays and Sundays in your total, you’ll have to work a bit harder.

You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the =networkdays ...