Rich - Thanks so much for your help on this. I continue to get an error for an Invalid expression. This is what I've entered. IF(Status='CPL',IF(ISBLANK(Complete Status Date),$$NOW,Complete Status Date),Complete Status Date) Any suggestions? Thanks!Meigan