Do you mean in VBA?

This returns the qtr of the current date

int((month(date)-1)/ 3)+1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tam76131 " wrote in message
...
Please help. I need to write a couple lines of codes in excel to tell
the worksheet if it's month 1,2,3 then place a certain in qtr1, if the
month number is 4,5,6 then place the value in qtr2. I don' think it's
too complicated but being new to vba.....i'm helpless....thanks for all
your help.

Tami


---
Message posted from http://www.ExcelForum.com/