Thread: Weekdays only!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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