A Al Nov 27, 2007 #1 I need to write a formula that calculates quarter for dates i.e. if cell D3 >12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.
I need to write a formula that calculates quarter for dates i.e. if cell D3 >12/31/2006 and <4/1/2007 then "Q1" and so on till Q4.
A Al Nov 28, 2007 #3 thanks it works Charles Chickering said: Al, try this: ="Q" & ROUNDUP(MONTH(D3)/3,0) Click to expand...
thanks it works Charles Chickering said: Al, try this: ="Q" & ROUNDUP(MONTH(D3)/3,0) Click to expand...
