Average Times on a monthly basis
In column A I have a list of all days for the year of 2014, formatted as "Tuesday, October 21, 2014". Then I have a table of the months in 2014, formatted at "October". How can I pull the average times for each of those months based on the two formats above?
I assume it is some sort of nested IF statement with a VLOOKUP, but I cannot get it to work? Any ideas?
Here is what my table looks like:
A2=October B2=the average time
The date ranges begin in column A starting at A8 and going down. The times completed are in column B starting at B8 and going down.
Thank you!
|