"yaabaa" skrev i melding
...
Thanks very much guys - both of your suggestions seem to work perfectly!!
Harald, why do you think that my original formula won't work until
February?

Sorry for the typo. I ment to say that the error will go away in february
all by itself. Month(0) is 1. So
Month(0) = Month(Date)
is true only in january.

HTH. Best wishes Harald