| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates test
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER): =MAX(IF((A1:A50=B1)*(A1:A50<=C1),A1:A50)) -- Regards Frank Kabel Frankfurt, Germany Ron2 wrote: Am trying to come up with a single cell formula (as opposed to a macro) that finds the maximum date from a range of 50 date cells (A1:A50) that falls between two dates that are listed in 2 separate date cells (B1 and C1). Thanks in advance. Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you help test our Excel test? | Excel Discussion (Misc queries) | |||
| How do I write an If(And( function using dates as my logical test? | Excel Worksheet Functions | |||
| Test if a date falls within a given range of dates in Excel? | Excel Worksheet Functions | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| test..where are my messages..test | New Users to Excel | |||
Threaded Mode
