Forum Discussion
formula for starting year and tenor
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. ...
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.
perfect. Thanks a lot