How can I format a cell to display the current quarter?
D David Biddulph May 6, 2008 #2 How do you define quarters? In what format do you want the answer to appear? Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
How do you define quarters? In what format do you want the answer to appear? Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
S S trainer May 6, 2008 #3 Thanks David! This is exactly what I needed David Biddulph said: How do you define quarters? In what format do you want the answer to appear? Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3) Click to expand...
Thanks David! This is exactly what I needed David Biddulph said: How do you define quarters? In what format do you want the answer to appear? Try =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3) Click to expand...
