HELP on Conditional Formats regarding Dates

I'm trying to make an exception that:

If the return value of say S11 = to any day between december 22-31 (of any particular year) therefore S11 should return " ".

Originally Posted by Ace_XL

Don't understand what you mean by conditionally format a cell as " "

But the logic would be on these lines..

=IF(TEXT(A1,"mmdd")*1>=1221," ",FALSE)

It's the set of holidays for the month of december so there would be no work during that time. So I need to mark these dates to result empty or " ".

Here's the catch why I'm having problem...

Because cell S11 is a string for cell R11, wherein S11 has a formula of:

=(IF(WEEKDAY(R11)=6,R11+3,R11+1))

So if the result of that string would be along the dates of December 21-30, then it should result into " ".

Originally Posted by Ace_XL

In that case

=IF(TEXT(IF(WEEKDAY(R11)=6,R11+3,R11+1),"mmdd")*1>=1222," ",IF(WEEKDAY(R11)=6,R11+3,R11+1))

yeah, it worked!!! Thanks a lot!!!

But by the way, is there a way to condition another cell with that string...

I mean that formula worked, so i would like to make another connection on another cell...

If S11 = " " (because of that formula) then cells s13:s20 should merge and produce a text "National Holiday".

the formula string:

In that case

=IF(TEXT(IF(WEEKDAY(R11)=6,R11+3,R11+1),"mmdd")*1>=1222," ",IF(WEEKDAY(R11)=6,R11+3,R11+1))

Does not work in a longer case... I was trying to apply the same concept for January 1 and 2....

the case was on H11 which had a formula of:

Please Login or Register  to view this content.

the code posted by ACE_XL was very helpful..

Please Login or Register  to view this content.

but what if there is a specific date complete with month, day and year?

I tried to use the same code but it doesn't work..