Excel already knows when the month ends.
AGGREGATE was built to handle messy data from the start.
Results that may be inaccessible to you are currently showing.
Hide inaccessible resultsResults that may be inaccessible to you are currently showing.
Hide inaccessible results