Re Colum with specific dates

Sipsoo

New Member
Joined
Jul 12, 2006
Messages
19
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
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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
ABCDEFG
19/1/2006sun1
26mon2
3tue3
4Tue329/08wed4
5Thurs531/08thurs5
6Fri601/09Fri6
7Sun103/09sat7
8Tue305/09
9Thurs507/09
10Fri608/09
11Sun110/09
12Tue312/09
13Thurs514/09
14Fri615/09
15Sun117/09
16Tue319/09
17Thurs521/09
18Fri622/09
19Sun124/09
20Tue326/09
21Thurs528/09
22Fri629/09
23Sun101/10
Sheet1
 

Forum statistics

Threads
1,136,310
Messages
5,675,002
Members
419,542
Latest member
shablagoo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top