I want a cell to reference two other cells and produce an estimated date based on their contents or lack thereof. So let me see if I can explain this......

I have a Cell (P9) that I want to generate an inspection date. The date will always be 365 days from the previous inspection date (J9). But forecasting purposes I may have to use estimated dates (I9). So i want P9 to look at J9 and say if there is a date entered in that cell, then use it+365 days. If not, then use I9+365 days. As soon as i come along and enter the actual date of the inspection in J9, then P9 would update itself with a new estimated date.


Here is what I have so far in cell P9: =IF(J9,BLANK,I9+365)

After that I have had zero luck nesting another IF statement.