Dates & their formatting

[Ian Dirnfeld]

I am trying to find a simple yet elegant solution to the following problem:
I need to type in a date and have it displayed in the following format:

Monday, January 1, 2006

I need then to be able to drag the cell and have the series of dates filled in, in the same format.

I have tried the =TEXT() format, but this requires a base cell (i.e. 2 arguments).

Is there any way to obviate this requirement, so I type in only one cell?

All help welcome!
Thanks,
Ian

 

[pgc01]

Hi Ian
Welcome to the board

Use the format

dddd, mmmm d, yyyy

Just write the first date and drag down

Hope this helps
PGC

 

[GlennUK]

Format the cell before you type the date in, as:
dddd, mmmm d, yyyy

 

[yee388]

Welcome to the board!

Other than the fact that 1/1/06 is a Sunday, just type in 1/1/06 into a cell, then go to Format Cell --> Number --> Date, and it should be the 2nd one in the list.

Once I did that, I could copy/drag that cell and it filled in each day in that format.

Hope this helps!

 

[yee388]

In fact, if you try to drag "Monday, January 1, 2006" anywhere, it will just incriment the year, becuase that date doesn't exist.

 

[Ian Dirnfeld]

Dates and their formatting

Thanks to all who replied -- what speed!

However, for some reason, the day is not being printed...
Any ideas?

 

[GlennUK]

Did you do a custom number format exactly as we said? ( with the dddd at the front? )

 

[Ian Dirnfeld]

Glenn-
No, clearly such simple instructions are beyond me...
trying now....
BRUTAL - it's coming up in Hebrew!
Any thoughts??