Dates & their formatting

Ian Dirnfeld

New Member
Joined
Oct 11, 2006
Messages
9
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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Format the cell before you type the date in, as:
dddd, mmmm d, yyyy
 

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
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

Well-known Member
Joined
Mar 7, 2004
Messages
1,374

ADVERTISEMENT

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

New Member
Joined
Oct 11, 2006
Messages
9
Dates and their formatting

Thanks to all who replied -- what speed!

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

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Did you do a custom number format exactly as we said? ( with the dddd at the front? )
 

Ian Dirnfeld

New Member
Joined
Oct 11, 2006
Messages
9
Glenn-
No, clearly such simple instructions are beyond me... :oops:
trying now....
BRUTAL - it's coming up in Hebrew!
Any thoughts??
 

Forum statistics

Threads
1,136,269
Messages
5,674,743
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top