Thread: Max if less than, Non-continuious array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ToddEZ ToddEZ is offline
external usenet poster
  
Posts: 60
Default Max if less than, Non-continuious array
I have dates in cells A1, C1, and E1. Cell F1 = 1/1/2009.

What formula can I use to find the maximum of cells A1, C1, and E1 IF AND
ONLY IF the date is is earlier than F1?


Reply With QuoteReply With Quote