formula

G

Glenda

I would like a formula to make the days of the week change
automatically. ie...Monday, Tuesday, Wednesday......
I already have the date (9-3-03) changing daily, but would
like the name of the day also to change. Is this possible?
 
J

J.E. McGimpsey

One way:

If your date is in A1, then in B1 put

=A1

and choose Format/Cells/Number/Custom "dddd"
 

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

Using a Date and corresponding weekday to pull amounts 1
Search closest day in the past from today 2
Countif Function?? 3
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Transfering information form one cell to another work sheet 14
Formulaes 1
Countif w/semicolon separated values 4
WEEKDAY 7

Top