This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello
Can you please help me find a resource to calculate in excel the "yellow" days on the following website: I want to calculate the days off in 2020 and 2021. Thank you
Here is the website showing "yellow" days off:
https://www.nalcbranch908.com/2019cal.html
There is a pattern to it, but I am having trouble making the calculation in excel. Here is the basic pattern:
Every Sunday is a day off
Every week there is another day off, but it rotates each week. On a week where the day off is friday, Saturday is also given so that it makes a 3 day weekend.
I am following the yellow color for days off on the calendar
I am trying to project my days off a year or two in advance so I can plan vacations/holidays.
Thank you.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This is much closer but still a bit off.
I've posted the wrong formula in B2, sorry:
B2: =IF(WEEKDAY(A2)=6,A2+1,"")
Andreas.
Hello
Thank you for the help. This is much closer but still a bit off. I included the next several weeks as an example below. If you have any ideas it is greatly appreciated.
The actual days off have a quirk in that when it falls on Friday, they also give Saturday and then skip the next week (So no days off between the next 2 Sundays). (This makes for a 3 day weekend every once in a while). For instance, the days off are as follows:
| Tuesday, July 2, 2019 |
|---|
| Sunday, July 7, 2019 |
| Wednesday, July 10, 2019 |
| Sunday, July 14, 2019 |
| Thursday, July 18, 2019 |
| Sunday, July 21, 2019 |
| Friday, July 26, 2019 |
| Saturday, July 27, 2019 |
| Sunday, July 28, 2019 |
| Sunday, August 4, 2019 |
| Monday, August 5, 2019 |
| Sunday, August 11, 2019 |
| Tuesday, August 13, 2019 |
| Sunday, August 18, 2019 |
A1: Regular Days
A2: 7/1/2019
A3: =A2+8+IF(B2<>"",2)
B1: Sundays
B2: =IF(WEEKDAY(A2)=6,A2,"")
and drag down
Andreas.