H
HGood
I have many Excel tables with columns with Dates in them in mmm-yyyy format.
I'd like to insert a new column to the right of each of these columns and
enter a formula in them to convert these formats. In the new column I'd like
the result to be Q1, Q2, Q3, or Q4.
I tried "=IF(MONTH(C3)=9,"Q3","")", and it works for the new column, if it
is September, it results with Q3.
But since there are 12 months in the year, I'd need to nest 12 of these IF
functions to cover all my bases, but Excel only lets me nest 7 deep.
How can I come up with an alternate way of doing this so it will evaluate
all 12 months in one formula, and each cell in the column result in either
Q1 to Q4.
Thanks,
Harold
I'd like to insert a new column to the right of each of these columns and
enter a formula in them to convert these formats. In the new column I'd like
the result to be Q1, Q2, Q3, or Q4.
I tried "=IF(MONTH(C3)=9,"Q3","")", and it works for the new column, if it
is September, it results with Q3.
But since there are 12 months in the year, I'd need to nest 12 of these IF
functions to cover all my bases, but Excel only lets me nest 7 deep.
How can I come up with an alternate way of doing this so it will evaluate
all 12 months in one formula, and each cell in the column result in either
Q1 to Q4.
Thanks,
Harold