View Single Post
  #5   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

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?