Calculate number of Sundays in the month asks how many Sundays there are to the end of the month. Two users proposed very similar answers that I liked and worked very well to determine how many Sundays to the end of the month. I'm looking for how many days without Sundays remain in a given month – this seems to be not exactly the same question – and I'm stuck.
What I'm using up to now, modifying this formula to
A1 on what would be the cell with the current month's first of the month (and each month's for each column), is:
(Total number of days in the month) - (today plus one to include today) - (minus the Sundays to today per the proposed solutions to the other question, minus 1 to exclude today if it's a Sunday), and that is where it breaks. I arbitrarily added the last
-1 (which in the parentheses it comes out as adding 1) but it really doesn't work.
I have a table with daily sales for the year, the daily average for each month and with the remaining days to the end of the month × the daily average, what the possible expected monthly sale would be. I include the current day on the Days Remaining because if today is a working day, there are sales, but I should exclude it if today is a Sunday, as we don't work on Sundays.
Is there a way to correctly determine, from a given day of the month included, how many days without Sundays remain in a given month? Maybe there is a better, more elegant way and I should be using a completely different formula :)