This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My company uses fiscal calendar for accounting, so the 1st month of is always February, and it ends with next year's January.
For example, we are in 2017 December, but for a Fiscal calendar, we call it Fiscal year 2018 December. The reason it is called Fiscal year 2018 is because it ends on 2018 Jan. And Dec is the 11th month of Fiscal year 2018.
I have no problem to converting the fiscal month to Calendar Month_nbr and Calendar Month_Name as below, however, I can't think of a formula or a work flow for converting the fiscal year to Calendar Year...