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