Breizze1313
New Member
- Joined
- Sep 26, 2023
- Messages
- 3
- Office Version
- 2021
- Platform
- Windows
I am trying to write a formula that shifts holidays that fall on Fridays or Saturdays to Thursdays. I have the formula to shift holidays that fall on Saturday or Sunday, but the shift to Thursday is alluding me. Please can anyone help with this??
The weekend shift to the Friday before or the Monday after is shown below
These are the dates I am specifically looking for right now, and can reverse engineer for others, I'm just stumbling with these specific dates right now.
The weekend shift to the Friday before or the Monday after is shown below
Observed Holidays | |||||
New Year's Day - Observed - No Work | =MONTH(G56) | =DAY(G56) | =DATE(year,B56,C56)+CHOOSE(WEEKDAY(DATE(year,B56,C56)),1,0,0,0,0,0,-1) | ||
Juneteenth - Observed - No Work | =MONTH(G68) | =DAY(G68) | =DATE(year,B68,C68)+CHOOSE(WEEKDAY(DATE(year,B68,C68)),1,0,0,0,0,0,-1) | ||
Independence Day - Observed - No Work | =MONTH(G69) | =DAY(G69) | =DATE(year,B69,C69)+CHOOSE(WEEKDAY(DATE(year,B69,C69)),1,0,0,0,0,0,-1) | ||
Veterans Day - Observed - No Work | =MONTH(G76) | =DAY(G76) | =DATE(year,B76,C76)+CHOOSE(WEEKDAY(DATE(year,B76,C76)),1,0,0,0,0,0,-1) | ||
Christmas Day - Observed - No Work | =MONTH(G80) | =DAY(G80) | =DATE(year,B80,C80)+CHOOSE(WEEKDAY(DATE(year,B80,C80)),1,0,0,0,0,0,-1) |
These are the dates I am specifically looking for right now, and can reverse engineer for others, I'm just stumbling with these specific dates right now.