If you want to learn more about the format, here is Microsoft’s documentation. If your weekends are different, you can use the NETWORKDAYS.INTL function to customize the weekend day. Note that NETWORKDAYS uses Saturday and Sunday as the default weekend days for its calculation. It also shows you how to remove the duplicates! Cell A1 is blank and A2 holds the description.).īy the way, if you have a long list of holiday dates and you’re not sure if it includes duplicates, the video below shows you how to check the data. ( I’m not showing cell A1 and A2 in the picture. This is two days less than the previous calculation because the formula found the list of dates in the cell range we provided. In cell F2, use the formula: =NETWORKDAYS(B2, C2, D2:E2).The first holiday date is in cell D2 and the second is in cell E2.That’s easier to understand with a worked example. You do this by entering each holiday into a range of cells and put the range into the Holiday’s parameter. You can give the formula a list of holidays to exclude in the calculation. That’s because there are two weekends during that timeframe (I double-checked). This is three days less than using simple subtraction. Taking the dates I used in the previous example (3rd January and 20th January 2023), the result from this Excel function is 14.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |