Sequence of 12 months shifting 1 month ahead each month

[Kiisj]

Hi, I think its a bit diffucult to explain the problem in the title so please take a look at the attached file.

The background story is that I want to make a forecast for expiring gift cards, which have a runtime for 12 months.

I was wondering if its possible to have a formula that can fill in the numbers for me from jan 22 to dec 23, so I dont need to copy and paste the numbers as I have done in the file.

Appreciate any help!

[Pete_UK]

You can use this formula in D3:

=IF(AND($A3<=D$1,$A3+365>D$1),$B3,"")

although you may need to use semicolons ( ; ) instead of commas ( , ) depending on your regional settings, then you can copy across and down as required.

Hope this helps.

Pete

[HansDouwe]

Please try in D3 and copy across and down:

Please Login or Register  to view this content.