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

Similar Threads

Day of the week and date 3
Auto Merge text from multiple sources 0
Template with fields and premade texts.. 0
Excel - Wich Function should I use? 1
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel 2000 and date math 4
Extra help on Nth Day of month 1

Top