stop calculating

[Likeexcel]

Hello:
How do I stop the formula from calculating if the date is past certain number of months?
Cell A1= 1/1/2020, Cell B1 is the current date 1/31/2022, now assume it returns zero after 12 months so in the case from 12/31/2020 on should return zero.

Below is my formula, it continues to calculate because I do not have a cap in the formula to get it to stop counting past 12 months.

=IFERROR(IF(B$1>$A1,MAX(B2-B3,0),0),0)

thank you for any suggestions!

 

[jtakw]

Ok, if the 2 dates might be the same, leave the formula alone, if not, you can skip the 2nd test as Micron suggested:

=IF(B$1>EDATE($A1,12),0,MAX(B2-B3,0))