| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Holidays
I have a date and a list of holidays. If this date is a holiday, how do I
make the date change to the next WORKDAY?....The WORKDAY function needs one to add days to a date and then gives a result.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Holidays
=IF(ISNUMBER(MATCH(A1,holidays,0)),WORKDAY(A1,1),A 1)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JB" wrote in message ... I have a date and a list of holidays. If this date is a holiday, how do I make the date change to the next WORKDAY?....The WORKDAY function needs one to add days to a date and then gives a result.. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Holidays
Thank you...that worked
"Bob Phillips" wrote: =IF(ISNUMBER(MATCH(A1,holidays,0)),WORKDAY(A1,1),A 1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JB" wrote in message ... I have a date and a list of holidays. If this date is a holiday, how do I make the date change to the next WORKDAY?....The WORKDAY function needs one to add days to a date and then gives a result.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help to build a list of holidays for 6 years | Excel Worksheet Functions | |||
| Holidays | Excel Worksheet Functions | |||
| Number of Week Days _including_ Holidays | Excel Worksheet Functions | |||
| Schedule to exclude weekends and holidays | Excel Discussion (Misc queries) | |||
| Skip the Holidays 2 | Excel Discussion (Misc queries) | |||
Linear Mode
