126+49=175
there are only 166 days, as the days are not in sequence? I end up with 164, as the first and last days are omitted… I guess you added the days that were not in sequence, as there are ‘2’ sets of consecutive dates…
You may be taking out holidays or something do come up with 166. Excel Help says that you can simply take the difference between two dates to come up with the number of days in between. Thus, you calculate the number of weekend days by taking the difference between total days and week days.