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 ...
Here is a version that should work in Excel 2016.
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.