I have a fiscal calendar where separates calendar months into fiscal months.
How can we input a function/formula when a fiscal month needs a “zero” as is “P04” and when it doesn’t need to, like a “P10”.
For example, this is the formula:
=”P0″&CHOOSE(MONTH([@Date]);4;5;6;7;8;9;10;11;12;1;2;3)
Also, how can I identify the fiscal weeks within this fiscal calendar? There are periods that contains 5 fiscal weeks instead of 4.
I tried to change using the IF function.
Sakram3ntum is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.