•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
Tagged with
#AI formula generation techniques
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#formula generator
#Excel alternatives
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#YEARselect
#Excel
#Gantt chart