Forum Discussion
Solved
Help With Dates in Excel
I've attached a copy of the Excel Spreadsheet that I'm using. There's a 3rd tab that I included in there as an example of how I want the dates to be returned.
When I type in the Year in K2, and select from the drop-down list the day of the week in K3, I want for cells C8, E8, G8, I8, and K8 to show me only the dates for Tuesday in January (represented by cell A8).
I also want cells C10, E10, G10, and K10 to show me only the dates for Tuesday in February (represented by A10).
This would continue down the calendar.
I've tried a bunch of different formulas and even tried using one of those AI Excel Formula generators to help me.
Here is a version that should work in Excel 2016.
6 Replies
See the attached version.
- It shows all of the dates! However, as soon as I either change the year in K2 or the day of the week in K3 (one or the other or both), all of the other cells say #NAME? which is the problem I was coming across myself. I can't seem to figure out how to make the formula work if I change the day or year.
Which version of Excel do you have? The formula that I posted works in Excel in Office 2021, Microsoft 365 and in the browser version.
