No when I used you formula on 12/08/2006 it gave me a 6 that is a Friday
the 6th day of the week. Anyway it doesn't matter this will not work
becuase
Sunday May 07, 2006 to Saturday May 06, 2006
Monday May 08, 2006 to Saturday May 06, 2006


Are not the same month on my calendar 05/07/06 is May 05/06/06 is April
becuase 05/07/2006 is the first sunday in May it begins May on my
calendar that is why I am going by week numbers my months go by week
numbers that is why I was writting the function.


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=537189