"Fred Smith" wrote in message
...
Your formula fails, Ashish, because 10/1/2008 to Excel is 10 divided by 1
divided by 2008. You need to use either Date(2008,10,1) or --"10/2/2008"

If using that format, use a non-ambiguous date format else it fails on some
systems, that is

--"2008-10/02"