Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weekdays of the month. | Excel Discussion (Misc queries) | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
Number of Weekdays | Excel Worksheet Functions | |||
WEEKENDS VS. WEEKDAYS | Excel Discussion (Misc queries) | |||
Weekdays | Excel Discussion (Misc queries) |