Hi, I am trying to prepare a holiday tracker for my team. I have a table with Statuary holidays dates, and run a formula for network days. However our employer has decided to reduce Fridays hours so Friday now becomes a 1/2 day holiday. Is there anyway I can alter my formula to make a Friday be half a day.
This is the formula I am using =NETWORKDAYS(B5,C5,$G$9:$G$15)
B5 = Start Date of Holiday
C5= End Date of Holiday
G9-G15 is the table of dates for statuary holidays
TIA
This is the formula I am using =NETWORKDAYS(B5,C5,$G$9:$G$15)
B5 = Start Date of Holiday
C5= End Date of Holiday
G9-G15 is the table of dates for statuary holidays
TIA