Monday, Tuesday, Wednesday, Thursday, Friday).
In the current version of Excel, the simplest approach is to use the FILTER function.
Both approaches are explained below.
If the value in F4 is changed to another day, the formula calculates a new result.
This array is returned to theIF functionas thelogical_test.
IF then acts as a filter to screen out values onotherdays of the week.
MAX automatically ignores FALSE values and returns the highest remaining value, 95.
Then we build a logical expression using the TEXT function to check all dates for Thursdays.
When used in a math operation, FALSE evaluates as zero, and throws a #DIV/0!
TRUE evaluates as 1 and returns the original value.
The final array of values and errors acts like a filter.
AGGREGATE ignores all errors and returns the largest (maximum) of the surviving values.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
in a text string with the number format of your choice.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
More than one condition can be tested by nesting IF functions.
