I knew there would be a smarter way!!

Andy.

"Roger Govier" wrote in message
...
Hi Sunny

Or you could simplify it to just =DAY(A1)

--
Regards

Roger Govier


"DB Explorer" wrote in message
oups.com...
Thanks Andy, this works perfectly, fine.

Sunny