Business-Day Formula/Algorithm for Excel

[ilubmoney]

Is there a formula for Excel that takes business days into account (when adding days to a date)? I am creating a spreadsheet template that will track deadlines, and if one date gets changed early on in the schedule, the rest will need to be adjusted as well. I want to have the spreadsheet be able to re-calculate deadlines when one date is changed (while also taking into account business days... I'm not too worried about holiday adjustments).

 

[SkipVought]

Take a look at the WORKDAY function from the Analysis Toolpak Addin.

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[ilubmoney]

Thanks very much!