Could it be something like the calc below?
"First of the Year"
This is one of those rare times I suggest blending. Why not just upload all your holidays into an Excel sheet and blend on those days? That way you won't have some bizarre long calc for every new day that comes in.
Here is a quick demo of what I'm referencing.
blend.twbx 1.2 MB
Thanks for the input. That looks definitely a smart way. I have never done any blending so far, but will try this one out. just wondering, what your excel file look like? something like :
1/1/2015 New year
1/1/2014 New year
1/1/2013 New year
I concur with Daniel. We have utilized the same method.
Please mark this as correct if this is now working for you. That way this is cleared from the unanswered questions.