Hi
Assuming you have the Analysis Toolpak loaded (ToolsAddinAnalysis Toolpak)
then with you starting date in A1
=workday(A1-1,5)
will return a Friday for dates falling on a Friday, Saturday or Sunday.
--
Regards
Roger Govier
"JJ" wrote in message
...
How do I set up the calander to exclude weekends in my schedule
calculation?
Est Start Date 04/01/2010
Leadtime = 5 days
Actual start date is 09/01/2010 which is a Saterday.
It would be great to change the act start dte to 08/01/2010 Friday.
Tx.
__________ Information from ESET Smart Security, version of virus
signature database 4741 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4741 (20100104) __________
The message was checked by ESET Smart Security.
http://www.eset.com