Date Range Look up
 

Hello,

Column E has a cost. Column F has a date. I need to know IF the DATE in
column F falls between a date range (I.e. 07/26/09 through 08/25/09), then
return the cost value in column E.

Any help would be much appreciated.

Rock-n-Roll!

Date Range Look up
 

=(F2=StartDate)*(F2<=EndDate)*E2

This would return 0 if the date is out of range or the Cost, if the
date is within the date range.

On 17 July, 16:28, Eric H wrote:
Hello,

Column E has a cost. *Column F has a date. *I need to know IF the DATE in
column F falls between a date range (I.e. 07/26/09 through 08/25/09), then
return the cost value in column E.

Any help would be much appreciated.

Rock-n-Roll!

Date Range Look up
 

Try

=IF(AND(F2=DATEVALUE("26-Jul-2009"),F2<=DATEVALUE("25-Aug-2009")),E2,0)

If this post helps click Yes
---------------
Jacob Skaria


"Eric H" wrote:

Hello,

Column E has a cost. Column F has a date. I need to know IF the DATE in
column F falls between a date range (I.e. 07/26/09 through 08/25/09), then
return the cost value in column E.

Any help would be much appreciated.

Rock-n-Roll!

Date Range Look up
 

Thank you!

"AB" wrote:

=(F2=StartDate)*(F2<=EndDate)*E2

This would return 0 if the date is out of range or the Cost, if the
date is within the date range.

On 17 July, 16:28, Eric H wrote:
Hello,

Column E has a cost. Column F has a date. I need to know IF the DATE in
column F falls between a date range (I.e. 07/26/09 through 08/25/09), then
return the cost value in column E.

Any help would be much appreciated.

Rock-n-Roll!