Date Comparison Formula

F

foofoo

Hello -

I am trying to set up a formula that compares 2 dates. My spreadsheet
is set up as shown below. If any of the dates between the DIST DATE
column and the DT DATE column fall within the month if DEC, then the
number populated in the DAILY REQ column should display in Column D.

Any suggestions?

A B C D E F
DT DATE DIST DATE DAILY REQ DEC JAN FEB
01/30/08 11/02/07 6.48 6.48 6.48
08/01/08
12/17/07 10/19/07 7.39 7.39
08/31/07 07/01/07 15.00
10/29/07

Thanks!

Sandi
 
T

T. Valko

I suppose you want to fill in the formula for *all* of the months?

Try this:

Assuming:

A1:F1 are column headers
A2:Bn are dates
All month names are in the short name format (mmm).

Enter this formula in D2 (D1 = column header = DEC) and copy across then
down as needed.

=IF(COUNT($A2:$B2)<2,"",IF(SUMPRODUCT(--(TEXT(ROW(INDIRECT($B2&":"&$A2)),"mmm")=D$1)),$C2,""))
 
Top