Dates test

  • Thread starter Thread starter Ron2
  • Start date Start date
R

Ron2

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
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=MAX(IF((A1:A50>=B1)*(A1:A50<=C1),A1:A50))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations Help 4
Looking for a Date forming function 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Compare shorter date range against longer date range 2
Find Highest Date in a range 4
Formula to calculate exact months and days between two dates 3
restrict a product eg 10*5=40 because 40 is maximum 1
Arithmetic with Cell Dates 1

Back
Top