Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add on 8 working days to a date
Hi I need to add 8 working days (excluding Saturdays and Sundays) onto a column of existing dates all of which may be different. I know I can use the NETWORKDAYS function to work out the difference between 2 dates but my problem here is that I only have one date and I need to add 8 working days onto it. Any help would be much appreciated. Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=520514 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add on 8 working days to a date
Use the brother of NETWORKDAYS: WORKDAY()
-- Kind regards, Niek Otten "Shirley Munro" wrote in message news:Shirley.Munro.24eie2_1141905610.3774@excelfor um-nospam.com... Hi I need to add 8 working days (excluding Saturdays and Sundays) onto a column of existing dates all of which may be different. I know I can use the NETWORKDAYS function to work out the difference between 2 dates but my problem here is that I only have one date and I need to add 8 working days onto it. Any help would be much appreciated. Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=520514 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add on 8 working days to a date
Thanks a lot Niek. This works just perfect. Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php...nfo&userid=836 View this thread: http://www.excelforum.com/showthread...hreadid=520514 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on a date + 30 days | Excel Discussion (Misc queries) | |||
business days - trade date plus 3 | Excel Worksheet Functions | |||
How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
How to project the due date according to a number of working hours | Excel Worksheet Functions | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) |