September to August Financial Year Calendar 10-27-2020 02:43 AM

[amitchandak]

September to August Financial Year Calendar

Date = CALENDAR(date(2014,09,01),Date(2021,08,31))
Start Of Year = STARTOFYEAR('Date'[Date],"8/31")
End of Year = ENDOFYEAR('Date'[Date],"8/31")
Qtr No = QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)+1
FY = "FY "&FORMAT('Date'[Start Of Year],"YYYY") & "-" &FORMAT('Date'[End of Year],"YYYY")
Qtr Year = "Q" & 'Date'[Qtr No] & " "& 'Date'[FY]
Month Year = FORMAT('Date'[Date],"MMMM YYYY")
Month Sort = DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH)+1
Qtr Start Date = DATEADD(STARTOFYEAR('Date'[Date],"8/31"),QUOTIENT(DATEDIFF('Date'[Start Of Year], 'Date'[Date],MONTH),3)*3,MONTH)

eyJrIjoiZWFhMWIzYzEtODA5MS00MWY4LThhMjktYmZlODAxMDFmZGFhIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9