Calculate Days Past in a Range of Dates

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.

To get the end of the month based on the date in column A use:

Please Login or Register  to view this content.

Then to get the number of days between you can either use:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

Thanks for the help. You came close; I'm going to use what you started to get the result I need. I'll let you know if it works.

BB