Hi! I have a report that has 4 columns with dates (not each cell has a date). I need to tally the number of scheduled calls and completed calls by manager. I would like to include this in my macro that does a bunch of other stuff to update the report. The dates come out of our system in yyyymmdd format, and I can use text to columns to change them to mm/dd/yyyy format.

In my limited knowledge, I feel like I need to use a concatentate to get the dates all in one column, then have a formula that will identify dates that have already occured versus dates in the future, then filter by manager with a filter that will tally the number of dates in the past and the number of dates in the future (completed versus scheduled calls), then copy and paste the totals onto the main report. This seems a little unwieldly and I am betting there is an easier way to do it. Keeping in mind that all this needs to be performed by the macro without anything being done by the user other than running the macro.

Any suggestions?

Thanks in advance for your help!