PDA

View Full Version : Need some help with date



doctortt
11-26-2012, 08:33 AM
Can one of the gurus here take a look at the file that I attached?

- On the "test" worksheet, I can't figure out what to do with the "Anniversary Flag" row, which is row 6.

-The model starts off by month and then turns to quarter.

-If you look at V6, the flag turns to 1 because that's the first anniversary

-However, AG6 is only the 11th month of the second year, and the column right next to it, which is AH6, immediately turns to a quarterly basis.

The question is how do I make the codes so that Excel can flag 1 after four quarters (because it's an anniversary) while keeping what I have now since the model starts off on a monthly basis

Thank you in advance

Bob Phillips
11-26-2012, 09:18 AM
-However, AG6 is only the 11th month of the second year, and the column right next to it, which is AH6, immediately turns to a quarterly basis.

The question is how do I make the codes so that Excel can flag 1 after four quarters (because it's an anniversary) while keeping what I have now since the model starts off on a monthly basis

What do those two statements mean?