I suggest you create a lookup table and then any data will return the
quarter you require. You will only need 12 or 13 dates in a column eg
jan 1 feb 1 etc and in column 2 put appropriate quarter.
--
robert111
------------------------------------------------------------------------
robert111's Profile:
http://www.excelforum.com/member.php...o&userid=31996
View this thread:
http://www.excelforum.com/showthread...hreadid=527081