| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add days without adding weekend
Hi
Trying to add 4 days to date in cell A1, without counting weekend and if poss bank holidays. in cell C1 example cell a1 = date cell b1 = time If time after 1600 hrs needs to be classed as next day. Then i have to add 4 days to that new date any help appriciated thanks in advance brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200603/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Adding Days (i.e. Mon, Tue, Wed, Thur...) to sheet | Excel Discussion (Misc queries) | |||
| Adding Work Days only in a function? | Excel Worksheet Functions | |||
| Weekend days other than Sat Sun | Excel Worksheet Functions | |||
Threaded Mode
