Listing months in columns based on user defined start month

**mashley** · 09-24-2014, 08:26 AM

i need to create column headings that display the 12 months. the first column would be a FY starting month selected by the user in a data validation field. columns to the right would then populate with sequential months, one month per column. FY starting month can be any of the 12 months. my trouble is restarting back to January when the start date is something other than January. Actual years do not need to be noted, only the months.

i could have the user select the fiscal ending month instead of the fiscal starting month if that makes it any easier.

Thanks.

**boopathiraja** · 09-24-2014, 08:31 AM

in b2 and drag it across

Formula:

Please Login or Register  to view this content.

**ChemistB** · 09-24-2014, 08:39 AM

With the dropdown in A1, I used this formula in B1 copied to the right

=IF(LEN(A1),INDEX(Months,MOD(MATCH(A1, Months,0),12)+1),"")
Months is a defined named range on sheet2. See attached