-1

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.

Improve this question
3
  • Not quite, the final output for the fiscal period must be read as "2023P08, 2023P09, 2023P10" and so forth.
    – Sakram3ntum
    Commented Jun 19 at 17:24
  • 1
    Try: =YEAR([@DATE])&"P"&CHOOSE(MONTH([@Date]);"04";"05";"06";"07";"08";"09";"10";"11";"12";"01";"02";"03")
    – bugdrown
    Commented Jun 20 at 8:47
  • 1
    That worked perfectly! Thank you!
    – Sakram3ntum
    Commented Jun 20 at 13:56
Related questions
0
How to calculate a fiscal day of year in Excel?
1
Given a 4-5-4 calendar and a date, how do I determine what fiscal week that date falls in?
1
SUMIFS to sum data between custom date range
Load 5 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.