How to Add 5 working days

T

Trying2Learn

Hello,

I've an Excel sheet with one column that contains dates. Now how can I add 5
working days to get a new date? If I add 5 days using Date funtion I might
get sat or sun.

Thanks
Trying2Learn
 
R

Ron Rosenfeld

Hello,

I've an Excel sheet with one column that contains dates. Now how can I add 5
working days to get a new date? If I add 5 days using Date funtion I might
get sat or sun.

Thanks
Trying2Learn
Click to expand...

Look in HELP for the WORKDAY worksheet function. Pay particular attention to
the part at the beginning that tells you what to do if you get the NAME error
message.


--ron
 
Top