2 columns of dates. Pivot occassions per month
I have 2 columns of dates of tasks performed.
I need to create a chart preferably pivot to show occurances per month of each. Would I need a 3rd column as it currently just used the first for the X-Axis. Or should I use a countif to create a new table counting how many times the month/year appears in each column? Can I use countif for month/year?
Thanks
I have 2 columns of dates of tasks performed.I need to create a chart preferably pivot to show occurances per month of each. Would I need a 3rd column as it currently just used the first for the X-Axis. Or should I use a countif to create a new table counting how many times the month/year appears in each column? Can I use countif for month/year? Thanks Read More