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.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2021-12-06 11:00:00 +0000
Seen: 16 times
Last updated: Aug 03 '22
How can user input be added to an array using a loop in C# and then displayed through printing?
How can the objects that are duplicated within a nested array be removed?
How can I resolve the ValueError regarding incompatible shapes between (None, 20, 9) and (None, 9)?
What is a more effective method to verify the type of an Array containing elements of any type?
What is the way to add up items in an array with two dimensions using Google Apps Script?
How can an array be filtered using the values in another array?
Can an Array of Elements be made in Android?
What is the method to separate two values in a single column of a numpy array?