Hello,
I'm a bit new to excel and not entirely sure how to ask this, but I need a formula to give me the date for the closest Monday to January 26th.
For example, based on the year these are the returning dates I need:
2015 - Jan 26
2016 - Jan 25
2017 - Jan 30
2018 - Jan 29
2019 - Jan 26
2020 - Jan 26
2021 - Jan 25
2022 - Jan 24
2023 - Jan 30
This is a little confusing but I need the formula to pull from a cell that contains the year. If Jan 26th of that year does not fall on a Monday, than I need the formula to give me the date that falls closest to that Monday. I hope this makes sense, any help would be appreciated!
Thank you,
Bookmarks