try this

=IF(LEFT(E6,4)<"2004","not",ROUNDUP(MID(E6,5,2)/3,0))

the yyyymmdd format is just not the way excel sees dates. This
solution should work. Let me know if this works out!


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=391959