Sh8dyDan
New Member
- Joined
- Dec 20, 2023
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
I need some help figuring out how to modify these two formulas. They work as expected. Instead of showing a blank when not election or inauguration year I'd like to show days till the next date.
Presidential Election Day
Presidential Inauguration Day
Presidential Election Day
Excel Formula:
=IF(MOD(YEAR(Timesheet!$E$22),4)=0,DATE(YEAR(Timesheet!$E$22),11,6)-(WEEKDAY(DATE(YEAR(Timesheet!$E$22),11,6))-2)+1,"")
Presidential Inauguration Day
Excel Formula:
=IF(MOD(YEAR(Timesheet!$E$22)-1,4)=0,DATE(YEAR(Timesheet!$E$22),1,20)+CHOOSE(WEEKDAY(DATE(YEAR(Timesheet!$E$22),1,20)),1,0,0,0,0,0,0),"")