Calculate Fiscal Year
Calculates fiscal year starting the month of October
Fiscal Year =
VAR fy_date = [Date] // replace with your date column here
RETURN
if(MONTH(fy_date) > 9, YEAR(fy_date)+1, YEAR(fy_date))
Last updated
Was this helpful?
Calculates fiscal year starting the month of October
Fiscal Year =
VAR fy_date = [Date] // replace with your date column here
RETURN
if(MONTH(fy_date) > 9, YEAR(fy_date)+1, YEAR(fy_date))
Last updated
Was this helpful?