Conditional Formatting

S

Steved

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

JLGWhiz

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

Steved

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top