format that or another cell
text(a1,"ddd")

--
Don Guillett
SalesAid Software

"SamanthaK" wrote in message
...
I am making a macro for Excel in which several lists exists. One of the
lists
contains the date. I want to use that date to check which day it is so
that I
can use this information in the other lists. Please help!

I am very thankful for any fast assistance!