View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Triggering a Flag after 10 days that excludes weekends and hol

Thank you Stefi. That worked. I take it you changed part of the formula from
(H11+10) to (H11,10) to take into account the modifications you made.


Not exactly! I changed
H11+10 to
WORKDAY(H11,10,Z1:Z10)
That's a new function with its own arguments!

I also
presume (tell me if I'm wrong) that when I enter the holildays into Column Z,
I will have to re-do this every year (as the dates for all except NY Day,
Independence Day and Christmas Day change yearly).


Have a look at Chip Pearson's site:

http://www.cpearson.com/excel/holidays.htm

It contains solutions for some floating holidays. If you can find a formula
for determining the date of a specific holiday, enter this formula in the
Holidays range, if not, then yes, you have to update Holidays range each year.

Regards,
Stefi