Opslået den 13.8.2019

ITSM&CI

Excel tip - Easter Sunday
Do you need to calculate holidays automatically for any year? Here is one formula which will help you:
=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1;19)-7;30)*14%;)*7-6
If you enter year number in cell A1, then formula will calculate the date when it is Easter Sunday for that year.
Smart?
Kontakt os
Meddelelsen er sendt. Du får svar hurtigst muligt.