I need help calculating the number of days that have past in a month based on a range (A:A) of dates and based on the amount of days in a month. The dates are not always sequential and weekend dates are not usually listed so if the month ends on a weekend it needs to account for this. I've attached a file for how it should look (COL C).

daysPast.xlsx

Thanks.