Date Range Look up

E

Eric H

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

AB

=(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.
 
J

Jacob Skaria

Try

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if a date comes before/after a range of dates 0
Date Formula 1
Complex Look Up (amended) 2
Sickness dates 4
Date Difference 2
Look up across multiple sheets 1
Complex Look Up 4
Pivot Table Dates 1

Top