Excel legal holiday calculation formula

Hello, the calculation formula of legal holidays in Excel is as follows:

1. Enter a set of working time data in excel, and calculate the annual leave time according to these data.

2. Enter the formula in cell B2: = if (A2

3. Click Enter to generate the calculation result. It can be seen that when the working hours are 100 or 2 years, the corresponding legal holidays are 5 days.

4. Click on the green circular point in the lower right corner of unit B2, and drag down the filling formula to calculate the legal holidays corresponding to different working hours in batches.