Weekdays only!

[Guest]

Hi All

I am using a simple formula that adds a number to a date field to give the
correct date. Eg if it take 3 days to complete a task the date + 3 give the
date 3 days later.

So far so good, however is there a way to make the formula miss out the
weekends?

Any help greatly appreciated

Kind regards

Rexmann

 

[Peo Sjoblom]

Lookup WORKDAY in help, it's part of the Analysis ToolPak but it comes with
Excel/Office

 

[Guest]

Hi Peo Sjoblom

Nice one, works a treat

Cheers G