The first worked fine for me. The second I had the slash backwards. Once I
changed that, it worked fine.

Can't explain your inability to use it. Sorry.

--
Regards,
Tom Ogilvy


"pamalpass" wrote
in message ...

Thanks for the quick response. I tried both versions but i get an error
13 type mismatch
on the line
dt = DateSerial(clng(sYear),clng(sMon),clng(sDay))


and the same error on the second example with the 'dt=' line

Paul


--
pamalpass
------------------------------------------------------------------------
pamalpass's Profile:
http://www.excelforum.com/member.php...o&userid=31952
View this thread: http://www.excelforum.com/showthread...hreadid=516726