I have written the following to the best of my ability but it isn't working.
Can anyone help me figure out what I'm doing wrong? E, G, H, I are givens and
I want it to caluclate K based them. The deadline (K) is whichever is sooner
the notice date (H) or G/I minus 105days. I wrote the four
situations/outcomes below to try to illustrate it.

=IF(AND(E20="CANCELLATION",H20<=DATE (YEAR(I20), MONTH(I20),
DAY(I20)-105))), H20, IF(AND (E20="CANCELLATION",H20 DATE (YEAR(I20),
MONTH(I20), DAY(I20)-105))), DATE(YEAR(I20),MONTH(I20),DAY(I20)-105),
DATE(YEAR(G20),MONTH(G20),DAY(G20)-105)))


A ... E ... G H I
K
Bldg Notice Exp Notice Effect
Deadline
Number Type Date Date Date
Date (-105)
20 Cancel 06/30/2011 06/01/2009 07/01/2009 I-105days

21 Cancel 06/30/2011 06/30/2009 07/01/2010 H
22 Other 11/30/2009 10/30/2009 12/01/2009 G-105days
23 Other 11/30/2009 01/30/2009 12/01/2009 H

Thank you in advance for your assistance. Elizabeth