Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Steved said:
Hello from Steved

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

=MONTH(A1)<>MONTH(A1+1)
Click to expand...

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.
 
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.
 
Back
Top