| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is date within a range?
I have a list of date & times of deliveries. I also have a list of date &
times of price changes. I want to identify if, for each delivery time, it falls within 7 hours either side of any one of the price changes and, if so, which side. Can anyone help? It would be much appreciated :-) |
|
#2
|
|||
|
|||
|
AndrewB wrote...
I have a list of date & times of deliveries. I also have a list of date & times of price changes. I want to identify if, for each delivery time, it falls within 7 hours either side of any one of the price changes and, if so, which side. Given a date/time of delivery, D, and the date time of a price change, C, the formula you seek is =IF(ABS(D-C)<=7/24,IF(D<C,"Before","On or After"),"Outside 7 Hours") If there were m delivery dates/times in a horizontal range D and n price change dates/times in a vertical range C, the formula above would be an array formula that would return an m-column by n-row array result. --------- www.coffeecozy.com Use your Bodum and give up cold coffee for good! |
|
#3
|
|||
|
|||
|
"hrlngrv - ExcelForums.com" wrote in
message ... AndrewB wrote... I have a list of date & times of deliveries. I also have a list of date & times of price changes. I want to identify if, for each delivery time, it falls within 7 hours either side of any one of the price changes and, if so, which side. Given a date/time of delivery, D, and the date time of a price change, C, the formula you seek is =IF(ABS(D-C)<=7/24,IF(D<C,"Before","On or After"),"Outside 7 Hours") If there were m delivery dates/times in a horizontal range D and n price change dates/times in a vertical range C, the formula above would be an array formula that would return an m-column by n-row array result. --------- www.coffeecozy.com Use your Bodum and give up cold coffee for good! Coffeecozy.com? -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting values within a Date Range | Excel Discussion (Misc queries) | |||
| Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Linear Mode
