Try these:

For the next 2 weeks from today:

=SUMPRODUCT(--(F2:F13=TODAY()),--(F2:F13<=TODAY()+14),--(G2:G13="Open"))

Greater than 2 weeks from today:

=SUMPRODUCT(--(F2:F13=TODAY()+14),--(G2:G13="Open"))

Or:

A1: =TODAY()

=SUMPRODUCT(--(F2:F13=A1),--(F2:F13<=A1+14),--(G2:G13="Open"))

=SUMPRODUCT(--(F2:F13=A1+14),--(G2:G13="Open"))


--
Biff
Microsoft Excel MVP


"Lisa" wrote in message
...
HELP!!! I have a formula that will tell me how many items are open with a
date in the past what I need now is one that will also tell me how many
open
items will be coming up in the next two weeks and one for anything over
two
weeks.. Any help would be greatly appreciated. Thanks in advance.

=SUMPRODUCT(--(F2:F13TODAY()),--(G2:G13="Open"))