you could try and compare the "text" value of the month of the date, eg
jan,feb,mar,apr. Make a lookup table where jan=1 feb=2 mar=3


so check if the number returned from the lookup table is <, = or the
number returned when AP6 is offered to the lookup table


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=536392