Forum Discussion
KevinCommunitas
Jul 11, 2023Copper Contributor
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 ...
- Jul 17, 2023
Here is a version that should work in Excel 2016.
KevinCommunitas
Jul 17, 2023Copper Contributor
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.
HansVogelaar
Jul 17, 2023MVP
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.
- KevinCommunitasJul 17, 2023Copper ContributorFigures it's a newer version that you're using. Our nonprofit has Microsoft Office Professional Plus 2016 on all of their computers.
- HansVogelaarJul 17, 2023MVP
Here is a version that should work in Excel 2016.
- KevinCommunitasJul 17, 2023Copper ContributorYou are a LIFESAVER!!! WOW!