| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
issue with adding weeks to the date
Hi I've got a problem where i have a list of dates, all of which i need to at six weeks to. that bit isn't to tricky, however, some of the dates could be either a saturday or sunday or bank holiday. If thats the case it then needs to add a day or two to the six weeks inorder to get it clear of a 'non working day' Also, if its around christmas, this issue is increased as the bank holidays are next to each other. Has anyone got any ideas on how to do this? theres about 14000 dates so doing it by hand could take a while!!! Thanks Matt   -- matthewwookie ------------------------------------------------------------------------ matthewwookie's Profile: http://www.excelforum.com/member.php...o&userid=27503 View this thread: http://www.excelforum.com/showthread...hreadid=473738 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate a date, 10 weeks after a set date & return a specific da | Excel Worksheet Functions | |||
| Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
| adding the total hours worked in 5 weeks | Excel Discussion (Misc queries) | |||
| Date 13 Weeks from now | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
![matthewwookie[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
