Weekdays only!
 

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

Weekdays only!
 

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


--
Regards,

Peo Sjoblom



"rexmann" wrote in message
...
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

Weekdays only!
 

Hi Peo Sjoblom

Nice one, works a treat

Cheers G

"Peo Sjoblom" wrote:

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


--
Regards,

Peo Sjoblom



"rexmann" wrote in message
...
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