I'm sorry, I misunderstood. That formula would be right for the DIFFERENT format. The "regular" format would be when there is no date, and the cell says P. Right? So try =(C18="P")*(D18=0)