date
 

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.

date
 

If in the same cell the right clickFormat cellsCustom type dddd

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


If this post helps click Yes
---------------
Jacob Skaria


"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.

date
 

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.