Currently we are looking to calculate the average number of calls per day, based on If Else conditions.
We want to start calculating the average calls from March 3, 2020 until March 31, 2020.
And also have the average calls of the other months starting from the 1st day of the month to the last day. I'm using Today().
But when we apply a filter for a past month, like March, the formula breaks, I was thinking in using Max(Call_Date) but it doesn't work if an Agent doesn't continue making calls during the following days of the month. I know there is a feature we could use, like a Master Calendar, but I don't know if this could help.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.