Hello -

Can anyone help me with a formula involving dates? I'm stumped. . .

I need to write the formula in cell A1. The formula needs to compare
today's date (in cell A2) with dates entered in calls A4 and A5. If
today's date in A2 is equal to or between the dates in cells A4 and
A5, AND if cell A8 which contains notes is blank, then the formula
result should display "Extract". If these conditions are not met,
then the formula result should display "Not Extract".

Examples of what I am looking for are shown below:

EXAMPLE 1
A1 A2 A4 A5 A8
Extract 9/6/07 9/4/07 9/24/07

EXAMPLE 2
A1 A2 A4 A5 A8
Not Extract 9/6/07 9/4/07 9/24/07 received via e-mail



Thanks!


Sandi