Hi there,

In the attached sample.xls, I have three column headings

1 Due Date
2 Closed Date
3 Status( has Data Validation List of "Open", "Closed" and "Overdue")

I want to do the following.

If Due Date is a day in the future and corresponding Closed Date field is empty or blank....I want Status to show as "Open"

If Due Date is past due(<Today()?), and Closed Date field is blank, Status to show as "Overdue"

If Closed Date field has a date entry, then Status to show as "Closed"

Any suggestions?

Nate

Typo in above post

If Due Date is past due(<Today()?), and Closed Date field is blank, Status to show as "Overdue"