September 11, 2023
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.
January 31, 2022