Originally Posted by
queuesef
A year has 12 periods. Depending on when the Fiscal year MONTH starts is when the year begins. Each month is given 1 through 12. So fiscal year starting in June (6/1/2021 ~ 5/31/22) would be Period 2 if you are in August 2021 [Jun= period 1; July = Period 2; Aug = 3.l..]
I believe for the October starting period the year would be 2021; period 1 = Oct '20; Per 2 = Nov 20; Per 3 = Dec 20; Per 4 = Jan 2021.....I generally start with their starting month and go out 12 months.... a June start would start: 6/1/2020 and go through 5/31/21. I look at it as 'the year going into, ONLY if it is NOT calendar year (Jan ~ Dec).
I hope this helps. [PS i changed your formula in cell B1 to "=IF((A2)=1,YEAR($D$2),YEAR($D$2)+1) " and copied it down. if you're fiscal is not Calendar, then you're in the next year]
Bookmarks