Revision history [back]
 | 1 | initial version |
You can use the MINIFS function in Google Sheets to find the nearest date in an array that matches a given date. Here's an example formula:
=MINIFS(A:A, A:A, ">="&B1)- where A:A is the range of dates and B1 is the cell containing the given date.
This formula will return the nearest date in column A that is greater than or equal to the date in cell B1. If you want to find the nearest date that is less than or equal to the given date, you can use the MAXIFS function instead:
=MAXIFS(A:A, A:A, "<="&B1)- where A:A is the range of dates and B1 is the cell containing the given date.