I need help displaying reminders based on how close the annual return date is to the current date. nnAll companies Limited by Shares (e.g cell C3) follow the A/R due date DATE(L3,K3,J3). nnAll companies that is Non-Hong Kong Company should follow the Inc/Reg date DATE(T12,S12, R12) and have the same reminder requirement as those Limited by SharesnnAll companies limited by guarantee also follow Inc/Reg date but only need to show reminder if less than one month from todays [login to view URL] am trying to get the formula to work for the last two conditions. As you can see, the problem starts at row 12 which is due to my formula. Any help will be much appreciated.