I have a date field and I am trying to find out the fiscal year for the same. I am currently using the following formula so as to get the fiscal year:
IF MONTH([Date])=12 THEN YEAR([Date])+1
ELSE YEAR([Date]) END
But my fiscal year calendar starts every first Sunday of every December. Please help me modify the formula so as the get the fiscal year.
Thanks in advance.