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