2025 Calendar Excel Formula. Here's how you can achieve this: You can also use this formula:

Calculate nights in each month with sumif. The number of days to go for the next holiday (number in the blue box).