How to Add 5 working days

[Guest]

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

 

[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

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