How to set formula to navigate the number in the table

[Shaopingfu]

If in the table I have Row Jan -Dec as the start month of a fiscal year, and column Jan-Dec is the calendar year month, how can I get the number in a cell if I know the DateTimeNow month, and which month is the fiscal year start month? 

[OTrieger]

@Shaopingfu 

You can be a logic with the formula tool to give you the number of months based on the given month. Another option is to transpose this table and then you will have 12 rows for Jan and 2 Rows for Feb etc. and then you can fitter the values base on the given month. I think that there are 4-5 different ways how to get what you are looking for.

[binuacs · Accepted solution]

@Shaopingfu One way of doing this

[pearl44snow]

Looking for the same issue!

[Gaurav_Dhama_ · Accepted solution]

Here is another approach.

Columns are auto created based on the months.