Modifying Formula to Show Days Till Next Presidential Election Day.

[Sh8dyDan]

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

=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

=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),"")

 

[Peter_SSs]

Could you give 2 or 3 examples of what might be in Timesheet!$E$22 and the corresponding results that you would want from the two modified formulas?

 

[Dave Patton]

=DATE(2024,11,6)-TODAY()

 

[Sh8dyDan]

Could you give 2 or 3 examples of what might be in Timesheet!$E$22 and the corresponding results that you would want from the two modified formulas?

Oh, sorry.
E22 on the Timesheet tab is just the starting date for a schedule
4/1/2024

 

[Sh8dyDan]

=DATE(2024,11,6)-TODAY()

Those formulas show the date every four years.

 

[Peter_SSs]

Oh, sorry.
E22 on the Timesheet tab is just the starting date for a schedule
4/1/2024

That does not provide the information that I requested.
Please also make it clear whether your dates are dmy or mdy format as we cannot tell from dates like 4/1/2024

 

[Sh8dyDan]

The Presidential Election Day formula will return the date for Tuesday after the first Monday of November for every year divisible by four. If the year is not divisible by four it will be FALSE and blank. Instead of showing blank, I'd like it to show days remaining until the formula is TRUE.

 

[Sh8dyDan]

That does not provide the information that I requested.
Please also make it clear whether your dates are dmy or mdy format as we cannot tell from dates like 4/1/2024

The date is in M/D/Y format.

 

[Dave Patton]

N.B. You can post a concise example of your sheet with the forum's tool named XL2BB.
• provide a clear explanation of what you are trying to calculate

T202401a.xlsm
	E	F	G	H	I	J
3	303				2024	Tue Nov 5, 2024
4	Tue 05-Nov-24				2028	Tue Nov 7, 2028
5				or	2032	Tue Nov 2, 2032
6	15-Apr-24	Tue 05-Nov-24	204	204
7	20-Nov-24	Tue 07-Nov-28	1448	1448
1e

Cell Formulas
Range	Formula
E3	E3	=DATE(2024,11,5)-TODAY()
J3:J5	J3	=WORKDAY.INTL(DATE(I3,11,0),1,"0111111")+1
F6:F7	F6	=XLOOKUP(E6,$J$3:$J$5,J$3:J$5,,1)
G6:G7	G6	=F6-E6
H6:H7	H6	=XLOOKUP(E6,$J$3:$J$5,J$3:J$5,,1)-E6

 

[Peter_SSs]

The date is in M/D/Y format.

Thanks. That addresses my latest point, but not the first.

• provide a clear explanation of what you are trying to calculate

I'm not criticising your request at all but for me, I don't want explanation as we have quite a bit of that. I would like concrete examples of the actual expected results for both formulas for a few dates in different (not divisible by 4) years.