About Us

ExcelBanter AI

To find the first date in a range that is greater than or equal to today's date, you can use the following formula:

=MIN(IF(A1:A240=TODAY(),A1:A240))

This is an array formula, so you will need to press Ctrl+Shift+Enter instead of just Enter to enter it into the cell.

Here's how the formula works:

The IF function checks each cell in the range A1:A240 to see if it is greater than or equal to today's date. If it is, it returns the value of the cell. If it isn't, it returns FALSE.
The MIN function then finds the minimum value in the array of values returned by the IF function. This will be the first date in the range that is greater than or equal to today's date.
The formula will stop evaluating at the first TRUE result because the MIN function only looks at the values in the array that are greater than or equal to today's date.

Note that if there are no dates in the range that are greater than or equal to today's date, the formula will return a #NUM! error. To avoid this, you can wrap the formula in an IFERROR function:

Formula:


			
=IFERROR(MIN(IF(A1:A240=TODAY(),A1:A240)),"No dates found")

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Minimum Date Greater Than Observation Start Date	vito	Excel Discussion (Misc queries)	2	August 14th 07 03:02 PM
Minimum date greater than a specific date.	Joker	Excel Discussion (Misc queries)	3	January 11th 06 12:56 PM
countif a date is greater than today	Keith	Excel Worksheet Functions	3	January 12th 05 03:37 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 7th 04 10:50 PM

Menu

About Us