Have you ever been faced with a contract that gives you 30 business days to respond? You could either pull out your calendar and count the business days, or use Excels Workdays formula.
The formula is simple
=2/1/2009+Workdays(start date, days, holidays)=3/14/2009
=2/1/2009+Workdays(2/1/2009, 30, 0)=3/14/2009
The workdays calculation tells you how many calendar days will pass by the time you’ve used 30 working days. Add this number to your start date and the result is your deadline.
For example:
** Make sure you activate Tools|Add-Ins and check Analysis Toolpak.
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare
One Comment