Column A has 12 months January through December.
Each month has several dates of deliveries.
I need a formula that will provide me with the average delivery date for each month and put the result in column B.
For example - column A goes from 2 to 200. All data is listed in date form (i.e. 1/12/2018) - January has 10 different delivery dates and 3 that are the same.
I would like all dates listed in January to be averaged and the result in column B (e.g. column heading "average by month" 1/13/2018 in B2; 2/4/2018 in B3, etc.).
Hope this makes sense.
Regards
Each month has several dates of deliveries.
I need a formula that will provide me with the average delivery date for each month and put the result in column B.
For example - column A goes from 2 to 200. All data is listed in date form (i.e. 1/12/2018) - January has 10 different delivery dates and 3 that are the same.
I would like all dates listed in January to be averaged and the result in column B (e.g. column heading "average by month" 1/13/2018 in B2; 2/4/2018 in B3, etc.).
Hope this makes sense.
Regards