day/date/year all together

[Dumber than a pocket full of rocks]

can I enter a day into my date & year and then drag to auto fill if so how?

[Gord Dibben]

Not sure what you want, but how about formatting the date as Custom

dddd, mmmm yyyy


Gord Dibben MS Excel MVP

On Mon, 3 Jul 2006 16:08:01 -0700, Dumber than a pocket full of rocks
<[email protected]> wrote:

>can I enter a day into my date & year and then drag to auto fill if so how?

[Marcelo]

Hi,

enter the date 04/Jul/2006 for eg

click on the little black squre on the right down of the selected cell end
drag to auto fill

hth
regards from Brazil
Marcelo

"Dumber than a pocket full of rocks" escreveu:

> can I enter a day into my date & year and then drag to auto fill if so how?