I have a list of dates in column A starting with:

5/1/2006
5/2/2006
5/3/2006
5/4/2006
5/5/2006
5/6/2006
5/7/2006
5/8/2006

How can I identify 5/1/2006 as being the first Monday of the month,
5/2/2006 being the first Tuesday of the month in column B? Where the
first Monday of the month is denoted by a 1 in column B. 5/8/2006 is
the 2nd Monday of the month so it would have a 2 in column B.

Is there a formula for this, thanks in advance


--
scwilly
------------------------------------------------------------------------
scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251
View this thread: http://www.excelforum.com/showthread...hreadid=536263