Forum Discussion
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...
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
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.
- You'r welcome