Hi there, thank you for your time. I see what you're saying. Here are the conditions below.

1. If K2 is "YES" then the cell must show "N", no matter what.
2. If K2 is blank, I need the cell to query my other IF function.
3. Other IF is - If the time between J2 - I2 is more than 14 days, the cell must show "N"
4. if the time between J2 - I2 is less than 14 days, and K2 is blank, the cell must show "Y"

Does the above make sense at all :S ?