Forum Discussion
Solved
Trying to fill in cell if a specific cell has number, then copy from one of three cells in order
I'm trying to make a scheduling calendar for work and we only use Microsoft. What I'm looking to do, is if the first Sunday of a month is the 1st (and only if the number 1 is the 1st Sunday of th...
And here is the (hopefully) completed workbook. Please test carefully.
Sorry, hopefully this works.
https://1drv.ms/x/s!Au-Zw7vw3BtFmBaS4SW0VK7ZT8WQ?e=JJcFt1
https://1drv.ms/x/s!Au-Zw7vw3BtFmBaS4SW0VK7ZT8WQ?e=JJcFt1
Thanks, got it.
Can you explain more clearly what you want? For example, how to choose between the last and second last Saturday of the previous month?
HansVogelaar basically start from the bottom of the previous month, and if there is nothing in that one go up to the next Saturday before that one. And with the rare occurrence that in Feb, the 28th falls on that one Saturday above the second to last one. Does that explain it a little better?
I'll take a look tomorrow, it's past midnight here.
- No worries. I greatly appreciate it!!! Have a great night.