Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a set date to which I need to add a number of days, but holidays
should not be counted. The cells of one of the columns in my spreadsheet holds the number of days, and I'd like to have results returned in the cell in the neighboring column. Something like this: 8/2/2008 5 8/7/2008 10 8/12/2008 30 9/2/2008 (30 days is 9/1, but that's a holiday, so 9/2 is right) Any ideas? I had been doing A1+B1 and it worked fine until I ran into needing to add Business Days instead of "regular days". So, I stared using =WORKDAY(A1,5). Neither excludes holidays though. Is there any way to have the number of days argument be a reference to another cell (b1 in my example) rather than having to put it in by hand? Thanks! J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
Conditional formatting to exclude weekend and Bank Holidays | Excel Worksheet Functions | |||
Conditional Formatting to exclude weekends and Bank Holidays | Excel Worksheet Functions | |||
Use networkdays INCLUDE weekends, Exclude holidays | Excel Worksheet Functions | |||
Schedule to exclude weekends and holidays | Excel Discussion (Misc queries) |