View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NN NN is offline
external usenet poster
 
Posts: 11
Default return a date from range, date is between dates in two other cells

I have a range of dates, S2:AF2. I need to search within that range to
locate any that are between the dates in two other cells, AG2 and AH2. If
none are between the dates, I wish the calculated cell to remain blank.