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)
As variant
with
=WORKDAY.INTL( C2, 1, 1 + ISEVEN( INT( (WORKDAY.INTL( C2, 1, 1 )-$C$2)/7 ) )*10)While I do not understand the formula, the table works and I thank you so much for your help.
Dianna Siderio , you are welcome.
With WORDAY.INTL we add to each previous date (first parameter) one day (second parameter) skipping weekend (third parameter). If third parameter = 1 we skip Sat and Sun, if = 11 when Sun only.
We make third parameter calculatable using 1 by default. If number of days between added one and very first date, divided by 7, is even (or, other words, even week number from start date), we add 10 to third parameter. Thus it is 11 for this week.
