How to change the starting and ending days of the months for each fiscal period

[Anonymous]

Hello, I have a question relating to how exactly I should go about incorporating fiscal periods in my Calendar Table. The fiscal period starts in January and ends in Decemeber (12 periods). The only problem is that the start date is usually not the first day of every month and the end date is not usually the last day of every month. 

ex.

January 1st - January 26th

January 27th - February 26th 

February 27th - March 26th

March 27th - April 26th

so on and so forth being the same, until the last fiscal period in December which starts November 27th and ends December 31st.

In the calander table I want the number of each fiscal period, 1-12, corresponding to the month of these set fiscal period start and end dates in a seperate column.

Thanks

[amitchandak]

@Anonymous , In your calendar table

Start Date of month = Switch(true() ,

month([Date])=1 && day([Date]) <= 26, eomonth([Date], -1)+1

month([Date])=12 , eomonth([Date], -2)+27,

eomonth([Date], -1)+27

)

End Date of month = Switch(true() ,

month([Date])=1 and day([Date]) <= 26, eomonth([Date], -1)+26

month([Date]) >=11 day([Date]) >  26 , Date(year([Date]),12,31)

eomonth([Date], 0)+26

)

[Anonymous]

@amitchandak Do you mind possibly breaking down and explaining your steps please? Would greatly appreciate that!

Thanks