Re Colum with specific dates

[Sipsoo]

Hi Group,

Need a bit of guidance please, I am trying to write a small macro that will put dates into a colum for specific dates.

So far I can input a month and year and the set up the spreadsheet as:

September 2006

Tue
Thurs
Fri
Sun

Tue
Thurs
Fri
Sun

Tue
Thurs
Fri
Sun

Tue
Thurs
Fri
Sun

Tue
Thurs
Fri
Sun

I want to get the dates next to the days in a 01/09 format...

Thanks inadvance

Ken

 

[venkat1926]

see the spreadsheet below

C1 is 9/1/2006 and c2 is the formula for the weekday
C1 is copied against first Friday. i.e. D6

Column C from C4 gives the serial no. of the weekday (see formulas in C4 down) using vlookup formula . formula in C4 is copied down
See formulas in D5 and copied to the above cell
See formula in D7 and copied down.
column D Formatted as customs format dd/mm

Book1
	A	B	C	D	E	F	G
1			9/1/2006			sun	1
2			6			mon	2
3						tue	3
4		Tue	3	29/08		wed	4
5		Thurs	5	31/08		thurs	5
6		Fri	6	01/09		Fri	6
7		Sun	1	03/09		sat	7
8		Tue	3	05/09
9		Thurs	5	07/09
10		Fri	6	08/09
11		Sun	1	10/09
12		Tue	3	12/09
13		Thurs	5	14/09
14		Fri	6	15/09
15		Sun	1	17/09
16		Tue	3	19/09
17		Thurs	5	21/09
18		Fri	6	22/09
19		Sun	1	24/09
20		Tue	3	26/09
21		Thurs	5	28/09
22		Fri	6	29/09
23		Sun	1	01/10
Sheet1