| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a date in between a range of dates.
I need help trying to pull information within a start date and end date. The
order date should be between the start and end date and then pull the correct discount that was applied at that time. ex... Record# Start Date End Date Disc 001 4/15/2006 4/15/2007 12.5 002 3/15/2005 4/14/2006 13.5 003 2/15/2004 4/13/2006 14.2 If the order date is 10/28/2005 then it should pull discount 13.5 because the order date falls within that range. I need to figure out how to program Excel to figure this out. I have 36,000 lines that I need to check against. Can anybody help me with this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200704/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding dates in a range | Excel Discussion (Misc queries) | |||
| finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
| finding a range of dates to total | Excel Discussion (Misc queries) | |||
| Finding dates within a date range | Excel Worksheet Functions | |||
| Finding Dates in a date range | Excel Discussion (Misc queries) | |||
Threaded Mode
