Hello,

I want to create a formula which I can copy and drag till the right end of my data. Contains data by employee how many days during a workweek they are in the office.  simple counting the 1's during the wordday's.  However there are addtional columns which I can't delete from the file.  For a few weeks this manually perfect to manage. but when you want to analyse more then year. its a lot of work.  

So is there a formula which I could use for this? in attached excel you find highlighted in yellow the working days of a month in June. and in the end column BG,BH and BI the end restult for these 3 weeks. then if the dataset will be minimum 52 weeks. can a formula make life a bit easier.

Thanks in advance for your suggestions.

Emiel