I have a sheet with lots of year to date data by month, the last column on
the right, which is AN, contains the abbreviated name of the month for each
row, formatted as m to show JAN, FEB,etc. This sheet is updated daily for
year to date info. I am trying to figure out an average month to date, so am
trying to figure out how to assign my JAN(in column AN) as the number of
months YTD. So for instance in this months column AN, it displays JUL next
to each row of information. in AO, I would like it to show 7 months current
YTD, then next month show 8 and so on. That way I can use that cell to
figure my average. How would I write a formula to do that?