Forum Discussion
thomaspowell250
May 24, 2023Copper Contributor
MAX date when less than another date
hi, im looking for a formula that will find the max date in a range where the date is less than another cell. example below of what im looking for (last_out date (expected result) i am trying t...
- May 25, 2023
=MAXIFS(Date_out_column,Barcode_column,Barcode,Date_out_column,"<"&Returned_date)
Detlef_Lewin
May 25, 2023Silver Contributor
=MAXIFS(Date_out_column,Barcode_column,Barcode,Date_out_column,"<"&Returned_date)