Write rest days for all year

[leprince2007]

Dear all,
2.png
I want to do this job using formulas or vba
Find the attachment

[dflak]

I'm solving this using some old technology: SUMPRODUCT. SUMPRODUCT doesn't get used much anymore. It's been mostly replaced with SUMIFS and COUNTIFS. However when you have to add in an additional function to make things match up, in this case MONTH(), SUMPRODUCT can handle it while COUNTIFS cannot.

You can see the formulas for yourself. SUMPRODUCT is not an array formula, but it acts like one and I use it to explain how array formulas work. This article explains how it works: http://www.utteraccess.com/wiki/Array_Formulas.

I also converted the data on the main sheet to an Excel Table. I find it easier to write formulas in terms of column headings instead of ranges like "'Data'!A2:A366"