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
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