the analysis toolpak (shipped with excel - so likely it is installed) offers
the workdays function. See Excel help for details.
--
Regards,
Tom Ogilvy
wrote in message
oups.com...
I'm using Excel 2003 to track a project. There are several cells with
formulas to calculate # of days prior to a set target date.
For example if I want to initiate an action 10 days prior to the target
date my cell reads "=A4-10" and it supplies the date. Is there a way
to have this calcuate in business days verses calendar days?
|