Calender

[abdullahsikandar]

Hi Guys,

I need to make an excel sheet, when that excel sheet will open, it will ask you for the calender, and once we select the calender it will automatically pops up the date and day on the top

like this:

Start of Excel:

Select Calender:
3/2/2015 - 3/8/2015

In columns:

[TABLE="width: 500"]
<tbody>[TR]
[TD]3/2/2015[/TD]
[TD]3/3/2015[/TD]
[TD]3/3/2015[/TD]
[TD]3/4/2015[/TD]
[TD]3/5/2015[/TD]
[TD]3/6/2015[/TD]
[TD]3/7/2015[/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I need some thing like this it will pop up automatically, let me know if you guys can help.

Thanks

 

[abmati]

I understand you question as under:
A1="Select Calendar"
A2=3/2/2015
B2=3/8/2015

In range A4:G4, please put the following formulas:
A4=A2 and A5=Text(A4,"dddd")
B4=EDATE(A4,1) and B5=Text(B4,"dddd")
C4=EDATE(B4,1) and C5=Text(C4,"dddd")
D4=EDATE(C4,1) and D5=Text(D5,"dddd")
E4=EDATE(D4,1) and E5=Text(E5,"dddd")
F4=EDATE(E4,1) and F5=Text(F4,"dddd")
G4=EDATE(F4,1) and G5=Text(G4,"dddd")

You can put condition like this:
G4=IF(EDATE(F4,1)>B2,"",EDATE(F4,1)

Regards

 

[abdullahsikandar]

I understand you question as under:
A1="Select Calendar"
A2=3/2/2015
B2=3/8/2015

In range A4:G4, please put the following formulas:
A4=A2 and A5=Text(A4,"dddd")
B4=EDATE(A4,1) and B5=Text(B4,"dddd")
C4=EDATE(B4,1) and C5=Text(C4,"dddd")
D4=EDATE(C4,1) and D5=Text(D5,"dddd")
E4=EDATE(D4,1) and E5=Text(E5,"dddd")
F4=EDATE(E4,1) and F5=Text(F4,"dddd")
G4=EDATE(F4,1) and G5=Text(G4,"dddd")

You can put condition like this:
G4=IF(EDATE(F4,1)>B2,"",EDATE(F4,1)

Regards

Actually, i need it in a way automatically.. like when the file will open it will ask us to select the week and it will automatically pop up the columns.