|when a report is due within 60 days of its expiration date to our customer. Here is a sample of the report|
DO Expires Due Date Submitted
My formula is =IF(B2<"12/01/2011", "Y","N").
B2 = Expires; for due date, I simply enter +B2+60 for the due date and that worked fine.
The problem is I am getting a "Y" for every cell instead of an "N" for cells that have an expiration date greater than 12/1/2011. What I want is if the expiration date is 11/30/2011, then C2 =Y and if not, then C2 is N. Also, I have not tried the formula for this part since I cannot get the first formula to work but I would like for the Submitted Date cell to turn bold. Please help.