Excel Unplugged

Tag Archives: DATE function

How to Highlight Weekend Dates in Excel Table

Highlighting Weekends can be hard in Excel. So just for fun, we’ll do this in three different ways: we’ll use conditional formatting to highlight the weekend ...

Last day of previous month formula in Excel

On many occasions we would like to somehow get the dates belonging to the last day of current, previous or any other month, the first day of this month or any day of ...