I have a table rows: salesman sales date (mm/dd/yyyy) for many years of sales
I am trying to isolate total number of sales of each salesman by month and day (excluding year)
excel dates are giving me fits
example:
salesman sales date
man1 2 5/1/2018
man 2 3 5/2/2018
man 1 4 4/1/2011
man 3 2 3/1/2017
man 1 4 5/2/2009
man 1 4 5/1/2017
results:
man 3 2 3/1
man 1 4 4/1
man 1 6 5/1
man 1 7 5/2
man 2 3 5/2
Thanks for any suggestions
I am trying to isolate total number of sales of each salesman by month and day (excluding year)
excel dates are giving me fits
example:
salesman sales date
man1 2 5/1/2018
man 2 3 5/2/2018
man 1 4 4/1/2011
man 3 2 3/1/2017
man 1 4 5/2/2009
man 1 4 5/1/2017
results:
man 3 2 3/1
man 1 4 4/1
man 1 6 5/1
man 1 7 5/2
man 2 3 5/2
Thanks for any suggestions