"mangesh_yadav " wrote in message ...
just use another if conditiion to check if D5 has a date or a "", and
accordingly set the value.


How?

Two question come to mind. One, does excel have a function to determine a cell's type, be it date or text? In JavaScript you have
typeof().

Two, does excel stop conditional testing? In Javascript, if you have if (typeof(a)=="string" & a < "g"), if the variable 'a' is
numeric you never see a < "g" executed...Dennis