On Friday, 7 May 2021 at 09:38:37 UTC+2, Claus Busch wrote:
I tested it with several dates and it always worked as expected.
I don't know why it doesn't work on your machine.
Can you send me the workbook?
Regards
Claus B.
--
Windows10
Microsoft 365 for business

Strange!
After renaming the macro (just because I didn't like the name I gave before) and re-assigning it
to the button, it works.
But the downloaded copy of your file, still doesn't work. Maybe you can have a look at it and see why?
I'll send them both to you.