|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 9th, 2006, 11:57 AM
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
March 9th, 2006, 12:11 PM
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
March 9th, 2006, 02:57 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding info to query | mjj4golf | Running & Setting Up Queries | 20 | January 9th, 2006 02:29 AM |
| Working days left in the month compared to previous months | qwopzxnm | Worksheet Functions | 8 | October 24th, 2005 08:00 PM |
| Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
| formula to Adding to working days | Suddes | General Discussion | 3 | July 30th, 2004 10:33 AM |
| Date formulas (date + no of days to return date mon-dri only) | Frank Kabel | Worksheet Functions | 0 | March 5th, 2004 11:27 AM |
Linear Mode
