Forum Discussion
Solved
Table showing Weekdays and Alternating Saturdays with dates beginning 4/11/2022
I would like to create a table in Excel Windows 10 that using a formula to automatically show weekday names with dates (month/day/year) and includes every other Saturday beginning with the date of 4/...
As variant
with
=WORKDAY.INTL( C2, 1, 1 + ISEVEN( INT( (WORKDAY.INTL( C2, 1, 1 )-$C$2)/7 ) )*10)
You can use a helper column ( A in this case)
Use the formula '=IF(MOD((D4-D$3),14)=12,2,1)' in each cell of column A - this compares the date for that row's date with the start date of Sunday 10/04 ( or 04/10 in US format).
If its the 12th day of the fortnight ie every 2nd Friday then the next row will add 2 days instead of 1 ie skips the Saturday
Thank you for your response.