Here is an example below:
Monday: 1
Tuesday: 2
Wednesday: 3
Thursday: 4
Friday: 5
Saturday: 5
Sunday: 5
Monday: 6
Tuesday: 7
And so on.
I am considering only working days. In a month there are roughly 23 working days on average. Therefore, at end of the month, the total accumulated cell value would be 23.
I calculate based on working days.
Now, instead of writing down the total working days in excel sheet and then calculating what is required makes the work quite boring and lengthy.
I'd like to have the working days accumulated automatically on daily basis but excluding Saturdays and Sundays.
I am actually currently using the below formula:
=TODAY()-DATE(2021,3,1)
I amend this formula to remove the weekends before using it further for the next week.
There should be the option in the formula of having to not only exclude weekends but any day that I would not like to add in the accumulation.
I hope I explained it well.
Please see enclosed as an example of what I would like to achieve.
Bookmarks