Hi

FormatCellsNumberCustomdddd dd mmm yyyy
Choose whatever format you prefer.

--
Regards

Roger Govier


"Negin" <Negin @discussions.microsoft.com wrote in message
...
Is there a formula or function that will tell me the day of the week
associated with a date i enter in excel???