Feb 20 2023 02:51 AM
hi together,
I need a formula that puts a "x" in the following columns out of two information (starting year) and (tenor)
So when in A2 is 2024 and in B2 is 2 I need an "x" in D2 and E2.
Can someone help me?
Best regards,
Wolf
Feb 20 2023 03:00 AM
In C2:
=IF(AND(C$1>=$A2,C$1<$A2+$B2),"x","")
Fill or copy to the right to the last column with a year, then down to the last row with a starting year and tenor.