See the other responses but the "date(...)" is treated as a text string
whereas the "" & date( ...) is treated as comparator + function in the same
way that you can use "" & A1.

HTH

"abanerji" wrote:


Thank you Toppers. I tried your second alternative ... it worked.

But, I am still academically curious as to why my
"date(year,month,day)" function inserted within the formula failed to
evaluate.
I think I have successfully embedded functions within other formulae
several times in the past.


--
abanerji
------------------------------------------------------------------------
abanerji's Profile: http://www.excelforum.com/member.php...o&userid=35382
View this thread: http://www.excelforum.com/showthread...hreadid=551513