I need help with a complicated conditional formula. Here is what I want
written out. I do not know how to translate that into an Excel formula. The
data is copied below.

IF column E "Phase" is equal to 1, AND there is data (an effective date less
than today's date) in column D "Effective Date" THEN I want Excel to COUNT
that.

I will also need to count Phases 2 and 3 as well, but let's just start with
Phase 1!!

I hope you can help me!!

I am using Excel 2003

Here is a portion of the data:

Effective Date Phase
1-Jan-07 1
6-Aug-08 2
1-Jun-07 3
1-Jun-07 3
17-Aug-07 2
1-Jun-07 2
15-Jun-07 2
1-Jun-07 2
1-Sep-06 1