1 of 1 people found this helpful
I didn't open your Excel file but this calc will give you the date you want:
DATE("11/30/" + STR(YEAR(TODAY())))
Of course this is in US date format, adjust if in UK.
I opened it. More work than I have time for. Maybe someone else wants to take it on. Or you could read the online manual about creating calculations.
Tableau Gurus, please help me on solving this calculation.