How do I add business days to a date field, no weekends?

O

Ozzy

I'm creating an excel spreadsheet and need to add business days only. If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
days, no weekends?
 
R

Ron Rosenfeld

I'm creating an excel spreadsheet and need to add business days only. If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1+5 business
days, no weekends?
Click to expand...


=WORKDAY(A1,5)

Check HELP for the WORKDAY function. There is an optional Holidays argument.
If you get a NAME error, you need to install the Analysis Tool Pak. This is
outlined in the HELP topic for the WORKDAY function.
--ron
 
Top