"Dana DeLouis" wrote
=TEXT(DATE(2001,1,A1),"dddd")
Much neater ! (For the "direct" suggestion to the example in the post)

Perhaps the function "VLOOKUP" might work better for your real data.
And this is much more apt an answer to the post !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----