date

[ann]

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.

 

[Jacob Skaria]

If in the same cell the right click>Format cells>Custom type dddd

If in cell A1 then use the below formula
=TEXT(A2,"dddd")


If this post helps click Yes

 

[Luke M]

formula in A1:
=A2
Format cell, custom:
dddd