Aug 19, 2007
I was given the formula below to calculate the quarter to date number. The months from 1/1/05 thru 12/31/07 are in cells C3-AL3.
View 9 Replies
First - can anyone explain the formula so I may understand it and possibly modify it for other uses
Second - wherever the formula has 3:3 and I copy it to the next cell below it, I have to change the 4:4 to a 3:3 - any suggestions on how to do this easily.
By the way, the formulas are in column AO, staring on row 4.