help with Date to appropriate day

[Marksman62]

Hi,
I am working on a spread sheet for my students that will insert the correct date (starting at the begining of the month) next to the appropriate day.
I'll explain,... The sheet is to record their work time for the month. It was built in excel 2003 and I am merely automating it to fill in the date in the cell next to the corresponding day. The days are listed in cell a8 starting with Monday. Cell a9 to cell a13 are the other days of the week, without Sunday. There are five weeks listed on the sheet. I have an entry point of the begining of the month on the top of the page with the month and year listed and formatted to show just that, in that cell (i2). When the student fills in the month and year I would like for the sheet to autocomplete the date next to the appropriate day leaving blank the days on the first week that were from the last month. (example; April 1st was a Friday, I want it to scan down to friday and insert 4/1 in the cell next to it (a12), then to begin counting from there to fill in the other dates. That part seems rather easy. It is just that first week that is a pain.
Should I use a macro or can I use a formula like "If" ?
Any help would be appreciated thank you.

 

[AlphaFrog]

Hi and welcome.

Maybe try something like this...

Excel Workbook
	A	B	I	J
1			Month	Year
2			April	2011
3
4
5
6
7
8	Monday
9	Tuesday
10	Wednesday
11	Thursday
12	Friday	4/1
13	Saturday	4/2
14	Monday	4/4
15	Tuesday	4/5
16	Wednesday	4/6
17	Thursday	4/7
18	Friday	4/8
19	Saturday	4/9
20	Monday	4/11
21	Tuesday	4/12
22	Wednesday	4/13
23	Thursday	4/14
24	Friday	4/15
25	Saturday	4/16
Sheet

 

[Marksman62]

Thank you very much. You are a genuis!

 

[Peter_SSs]

Does it work for May 2011 (day 1 falls on a Sunday)?

Using a couple more helper cells at the top could mean a reasonably simple formula could be used all the way down. Formula in B8 is copied down the column. Partial screen shots shown for April & May. (My date format is d/mm/yyyy)

Excel Workbook
	A	B	I	J	K	L
1			Month	Year	Day 1 (Date)	Day 1 (Text)
2			April	2011	1/04/2011	Friday
3
4
5
6
7
8	Monday
9	Tuesday
10	Wednesday
11	Thursday
12	Friday	1/04/2011
13	Saturday	2/04/2011
14	Monday	4/04/2011
15	Tuesday	5/04/2011
16	Wednesday	6/04/2011
17	Thursday	7/04/2011
18	Friday	8/04/2011
19	Saturday	9/04/2011
20	Monday	11/04/2011
21	Tuesday	12/04/2011
22	Wednesday	13/04/2011
Dates

Excel Workbook
	A	B	I	J	K	L
1			Month	Year	Day 1 (Date)	Day 1 (Text)
2			May	2011	2/05/2011	Monday
3
4
5
6
7
8	Monday	2/05/2011
9	Tuesday	3/05/2011
10	Wednesday	4/05/2011
11	Thursday	5/05/2011
12	Friday	6/05/2011
13	Saturday	7/05/2011
14	Monday	9/05/2011
15	Tuesday	10/05/2011
16	Wednesday	11/05/2011
17	Thursday	12/05/2011
18	Friday	13/05/2011
19	Saturday	14/05/2011
20	Monday	16/05/2011
21	Tuesday	17/05/2011
22	Wednesday	18/05/2011
Dates