Thread: Conditional Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steved Steved is offline
external usenet poster
  
Posts: 519
Default 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.
Reply With QuoteReply With Quote