Forum Discussion
Jarvo
Mar 16, 2021Copper Contributor
How to change the dates according to a year selected in a drop down list
Hi everyone! I've been scratching my head and I'm sure there is a simple solution. On the spreadsheet you'll see a drop down list at the top where you can select the current year and subsequent y...
tauqeeracma
Mar 16, 2021Iron Contributor
Hi Jarvo
You may use below formula :
="Mar-"&RIGHT($E$2,2) so it will be changed when year will be changed.
This formula will work in regular cell but I doubt it will work if cells are Hearders of a table (as in your case).
A sample file is also attached for your reference. Please let me know if it works for you.
Thanks
Tauqeer
- JarvoMar 16, 2021Copper Contributor
Thanks! Yeah as was suggested in the other response, the table headers don't allow for functions/formulas (which I hadn't realised). So I've done an alternative for table headers and your formula works! Thank you very much you've helped me a lot here.
- tauqeeracmaMar 16, 2021Iron ContributorYou'r welcome