populating my data onto calendar

[Ganesha Deshpande]

i have 5 weeks plan in attached file and i would just need the formula that would be inserted into each calendar day? I'm not sure how you would set this up

I have attached the excel file for your reference.

 

[Somendra Misra]

Hi Ganesha,

Welcome to chandoo forum.

You did not mentioned anything about your required output?

Regards,

 

[Ganesha Deshpande]

my required output is if
if today is 1 nov 2013 its first saturday as per calender and as per my schedule its Thane

 

[Somendra Misra]

So instead of dates you want names of cities to show in your calendar?

Regards,

 

[Ganesha Deshpande]

yes sir

 

[Ganesha Deshpande]

is it possible through any formula or any macros its very important for me

 

[Ganesha Deshpande]

instead of dates i want week wise city names in calendar

 

[Somendra Misra]

See the file.

Regards,

 

[sgmpatnaik]

@Somendra Misra

It will look good or not if we mention the Day also in the Calendar with little bit add in your formula

=IF(B15="","",INDEX("Day " & B15 &" - " &$C$5:$I$9,ROWS(J$15:J15),MATCH(J$14,$C$4:$I$4,0)))

Thanks

 

[Ganesha Deshpande]

thank u so much sir ji. your help is lot lot me its solved my all the problem................ thanks once again

 

[Ganesha Deshpande]

above formula is awesome...........

 

[sgmpatnaik]

Glad it helps you

 

[Ganesha Deshpande]

ur formula do work after miner changes in calender plz check sheet work........