Hi,

Am Wed, 26 Feb 2014 22:11:22 -0800 (PST) schrieb Akash Maheshwari:

In Cell A1 there is a date.

There should be a formula in Cell B1 where automatically the value should get displayed as Q1, Q2, Q3 or Q4

try:
="Q"&ROUNDUP(MONTH(A1)/3,0)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2