"Steved" wrote:

Hello from Steved

The below will find the last day off the month for the whole year.

=MONTH(A1)<MONTH(A1+1)

I get True on my computer. Are you looking for the day of the week for the
6th of each month? Or do you want to return the 6th of each month to a
variable? Since your example doesn't do what you said it did, it is hard to
tell what you are trying to do.