date

A

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top