Hi admanirv
thanks for that allthough it just displays one date in k2, ie 6mar.
You get the date, as the code given by Leith returns a 2-5 which excel
converts to date. I have modifed that code to return 2 to 4 instead of
2 - 4. Another method would be to return '2-4 telling excel explicitly
that this is a text and not date
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=374117