•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
=YEARselect formula in Excel
I have recently taken over a spreadsheet from a colleague who has left. They had a Gantt chart created on a tab which shows the year and months below.
The years it shows are 2025 and 2026. I don’t want 2025 to be visible anymore. Instead I want to see 2026 and 2027.
I’ve found that there’s a formula hidden on the page which says =YEARselect, there is nothing more than this. If I delete it, both 2025 and 2026 disappear. I have no idea where it’s pulling the years from. What can I do?
[link] [comments]
Want to read more?
Check out the full article on the original site