Matthias

... as long as you keep "2, 31", I don't insist on a special year I tried the script on my system and had some problems with the CDate-function, because it doesn't cut off the time from the date when it's given with "now". And therefore I didn't get any holiday except the call is at midnight. I changed the calculation of the year and the at the beginning a little bit and moved the DateSerial from the function-call into the function. With the change, you can call the function in the following ways: IsPublicHoliday (vb_FS_NI, "")IsPublicHoliday (vb_FS_NI, Now)IsPublicHoliday (vb_FS_NI, "29.2.2016") [ADMIN EDIT: copied the script code into the first post of this thread] and I also fixed the Sachsen-bug Cheers, Matthias

Hey Younes, dutch or not - Easter has the same place in the calendar. So, don't care for the calculation, just use it :-) The key-part after the calculation is the line "Ostersonntag = DateSerial(nTempYear, 3, e + f + 22)". Every other holiday around easter is calculated relatively to that day. The harder part for you is to define all national and (so they exist) regional holidays for the netherlands, but this should be mostly work, not brainwork. And don't forget to insert: FootballChampion = DateSerial(9999, 2, 31) Cheers, Matthias