Hi, Can someone please help me create 1 formula with the conditions below. The formula will be in cell P2. I appreciate the help.
If W2 says CLOZ then Y2-AE
If W2 says CANCELLED then Y2-AF
If W2 says anything other than CLOZ or CANCELLED then Today()-1-Y2