I have time tracking worksheet that I use at work. It looks something like this:
| Task | Total Hours | Friday, 9/7/2007 | Saturday, 9/8/2007 | … |
| Status Report | 5.25 | 1.5 | 0 | … |
| Staff Meeting | 12.5 | 1.5 | 0 | … |
| … | … | … | … | … |
Since I don’t work on Saturday or Sunday, I’d like to hide all columns that have a date that’s a Saturday or Sunday.
Here’s a little VB macro that will do the trick:
h/t Rowan
(Visited 27 times, 1 visits today)