Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Monday, July 30, 2007

Episode 560 - Negative Workdays

How can you figure out a date that is a certain number or workdays BEFORE a date? On the last episode of The Lab with Leo Laporte, I showed how to calculate a date 45 workdays after a certain date. Today’s question is how to calculate the date 5 days before the end of the month. Episode 560 shows you how to calculate this value.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: , ,