Hello Everyone!
I am in a bit of a rut here, and I can't seem to figure out how to do this. I am trying to make a turnaround time calendar, and it needed to include only working days vs the entire week.
This has been accomplished, but I need to add a condition, so I can also exclude specific days to not count as working days.
This is the formula that I am using: =IF(ISNUMBER(A24),WORKDAY(A24&LOOKUP("zzz",A$2:A24)&A$1,8),"")
I need to exclude: May 28, July 4, Sept 3, Nov 22-23, Dec 24-25.
Where do I add the exception? Your help is greatly appreciated! Infinia Patient Scheduler 2012.xls
Bookmarks