How to calculate holidays in Excel To calculate the holiday days that we are going to enjoy on an Excel sheet, the first thing we need to know is whether the holiday days per year are counted as natural days or as business days. Both types of work holiday days mean the same rest time, they are simply counted differently. The natural days of holidays in Spain are 30 by law and include Sundays and holidays. In contrast, some labor agreements prefer to count the holidays as working days (without holidays) so they are 22.
Once we are clear how to count the vacation days in Excel, we need to enter in an Excel spreadsheet the data related to the start and end dates of the holidays. The template in Excel to make the calculation of the holiday must have inserted the functions of Excel more suitable according to the format of vacations in Excel:
Calculate in Excel the vacations when subtracting the dates in Excel
Calculate in Excel the holidays without counting the weekends
Calculate in Excel the holidays without Counting Weekends or holidays
For more details please use some of the examples below as your guide: