formula in A1:
=A2
Format cell, custom:
dddd
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ann" wrote:

I need to have the name of the day of the month automatically fill in when I
enter in the date.

Ex: enter in 1/1/2009 in cell a2
In cell A1 Monday will automatically be filled in.

I guess this is a matching of the date to the name of the day of the month.

thanks.