| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a formula with a date range
i have a list of dates that i want to pull into one roll if
example: IF dates between 7-1-07 and 7/8/07 than choose 7/8/07 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create a formula with a date range
On Fri, 24 Aug 2007 20:08:01 -0700, Kimber
wrote: i have a list of dates that i want to pull into one roll if example: IF dates between 7-1-07 and 7/8/07 than choose 7/8/07 Is between inclusive? What if date is not between the two dates? In general: =if(and(date=date1,date<=date2),date2,"date not between date1 and date2") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| how do i create a formula for selected range? | Excel Worksheet Functions | |||
| How to create a formula for a range of cells | Excel Worksheet Functions | |||
Linear Mode
