Conditional Formatting
 

Hello from Steved

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

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

Can the above formula be change please to find June 6th if so how. June the
6th is a public holiday.

Thankyou.

Conditional Formatting
 

"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.

Conditional Formatting
 

Hello from Steved

The below will find the last day off each month

How would I go about finding a particular day for example 6th of June please.

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

Thankyou.

"JLGWhiz" wrote:



"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.