Need to make new column with quarter based on date in anothe column

[Kressmi]

<TABLE style="WIDTH: 108pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=144><COLGROUP><COL style="WIDTH: 54pt" span=2 width=72><TBODY><TR style="HEIGHT: 42pt" height=56><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 42pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl63 height=56 width=72>TTP P
-20 Wks
FFV</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl63 width=72>Quarter P</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl64 height=19 align=right>1/5/2004</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl64> </TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl64 height=19 align=right>9/13/2011</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #ece9d8" class=xl64> </TD></TR></TBODY></TABLE>

 

[doublej_jj]

Need more specifics:

Do you want in the second column the date of an ending quarter?

* 1/5/04 would be 3/31/04?
* 9/13/11 would be 9/30/11?

Try asking with more detail the results that you want to appear based on what criteria.

As Stephen Covey would say, "Start with the end in mind!"

Jeff

 

[Kressmi]

would like to see:

1/31/11 would be 1Q11
5/25/11 would be 2Q11
8/4/11 would be 3Q11