The quarters are easy. If the date is in A1 then:
=CHOOSE(CEILING(MONTH(A1)/3,1),"Q1","Q2","Q3","Q4")
will give the correct quarter. I don't understand your week number.
Please update the post.
--
Gary''s Student
"mazalam" wrote:
I have a column A with 1000 different dates. I want excel to look up the
dates and if it falls under a specific date range, label column "B"s
respective cells a certain Fiscal week.
For example:
1/31/2005 Q1,WK1
2/1/2005 Q1,Wk1
2/2/2005 Q1,Wk1
2/3/2005 Q1,Wk1
2/4/2005 Q1,Wk1
2/7/2005 Q1,Wk2
2/8/2005 Q1,Wk2
2/9/2005 Q1,Wk2
2/10/2005 Q1,Wk2
2/11/2005 Q1,Wk2
--
mazalam
------------------------------------------------------------------------
mazalam's Profile: http://www.excelforum.com/member.php...o&userid=26768
View this thread: http://www.excelforum.com/showthread...hreadid=468810