Automating consecutive dates matching dates of the week in columns

[JER]

I want column A to show the consecutive dates of the month of July from the
1st to the 31st. Column B would have the day of the week next to the dates
as illustrated below starting with Thursday, as is the case with the month
of July

A B
|Monday
|Tuesday
|Wednesday
1st | Thursday
2nd | Friday
3rd | Saturday
4th |Sunday
5th |Monday
6th |Tuesday

Is there any way to automate the process of the insertion of the date once I
begin with typing in "1st" next to Thursday? Can I get Excel to
automatically fill in "2nd" next to Friday, 3rd next to Saturday and etc.,
all the way to the end of the month ... the 31st

Next month, for August, I will erase all of column A and start with entering
"1st" next to Sunday and duplicate the process all over again. I don't work
with Excel that much, but seem to remember doing something like this a
number of years back. If this is possible, please .... a step by step
process for this novice.

Thank you so much for any help

Appreciatively
Jerry

 

[Biff]

Hi Jerry!

Why delete those entries? Just select that whole block of
cells in col A and move it up or down accordingly.

Biff

 

[Llobid]

I'm not sure if this is what you're wanting, but if you type 8/1/2004 i
A1 and Sunday in B1, then Excel can automatically fill down as far a
you want.

Highlight both cells then grab the fill handle (the little black box a
the bottom right corner of your cells) and drag down. Watch the date
as you drag down...when you reach 8/31/2004...stop. All of your day
and dates will be matched properly

 

[Frank Kabel]

Hi Jerry
I would do this differently If you want i kind of calendar try the
following:
A1: enter the year you want. e.g. 2004
B1: enter the month number. e.g. 7 (for July)

Now enter the following formulas:
A2:
=IF(MONTH(DATE($A$1,$B$1,ROW(1:1)))=$B$1,DATE($A$1,$B$1,ROW(1:1)),"")
and format this cell with the custom format 'D'
B2:
=A2
format this cell with the custom format 'DDDD'

copy both cells down to row 32. Now just change the values in cell a1,
B1 and the calendar updates automatically. Note: column A shows only
the day number (without 'st', 'nd', etc.)

 

[JER]

Thanks to all of you. Exactly what I want to know and do. I learned
something from each of you. Thanks again

Jerry