Please enable JavaScript to view the comments powered by Disqus.


DAY(...A1)=MAX(...(...MONTH(...$A$1:$A$6)=MONTH(...A1))*(...YEAR(...$A$1:$A$6)=YEAR(...A1))*DAY(...$A$1:$A$6))

Checking if a date is maximum for all dates for the same month

The formula first collect the year and month information from the data and then the corresponding date as an array. That array is used to find the max for the month and then it is compared to respective cell for TRUE or FALSE results.


Used Functions

Category: Date and time

Converts a serial number to a day of the month

Syntax

DAY(serial_number)

Category: Statistical

Returns the maximum value in a list of arguments

Syntax

MAX(number1, [number2], ...)

Category: Date and time

Converts a serial number to a month

Syntax

MONTH(serial_number)

Category: Date and time

Converts a serial number to a year

Syntax

YEAR(serial_number)

Lets chat on this