Day and Date

[dah]

Hi,

Is there a way to have the day and date come up automatically in
spreadsheet - say I type the first row and drag down for the rest. Fo
example:

Monday 4/5/04
Tuesday 4/6/04
Wednesday 4/7/04

and so on - without typing the info each time. I know you can do th
days with a custom list but is there a way to incorporate both?
tried the custom list with a NOW function but that didn't work. An
suggestions?

Thank

 

[Dave Peterson]

Not quite automatic:

Ctrl-; (control-semi colon) to enter the first date
Format|cells|number tab|Custom
dddd mm/dd/yyyy

And rightclick on the autofill button and drag down. When you let go, you'll be
prompted for what you want (fill days, fill weekdays...

And my favorite custom format for this kind of thing:

dddd* mm/dd/yyyy

Try it and then widen the column.

 

[dah]

Thanks -

That works well. Only took a few seconds. Do you think that sam
process would work if I recorded a macro while doing so? That migh
save even more time. I'll try that next.

Thanks agai

 

[Dave Peterson]

Sure.

and look at Date in VBA's help (to get today's date).

with activesheet
with .range("a1")
.value = date
.numberformat = "dddd mm/dd/yyyy"
end with
end with