Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |