If the value in cell A1 is input as 1Q’24, then I want $2M in Row 3, column 1Q’25 (basically after four quarters), if the value in A1 is 2Q’24 then $2M should be in Row 3, 2Q’25 column (after four quarters)

Closed 15 days ago.

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

I have data where the “Frequency” is defined in Columns N as weeks or months, and “last completed date” in Column M. The frequencies are:

So I’m trying to do an offer price algorithm.