Cascading Dropdown for A Calendar

[pspunlimited]

HI,

I want to create an excel formula with a cascading dropdown, wherein

if I choose February on dropdown It will Display the Columns Week 1 - 5

haha.JPG


If I choose january it will display Columns Week 1 - 4

wawa.JPG

so Like a calendar having Weeks only to display

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[samba_ravi]

Why Jan has 4 Weeks and Feb has 5 Weeks
and pls attach sample excel file

[pspunlimited]

See Attached. What I want is that if January will display only weeks 1 - 5 and if i choose from dropdown February It will be Weeks 1 - 5. in short, choosing from dropdown changes the Excel Cells

[:) Sixthsense :)]

What is your expected Weeks for Feb 2015 and May 2015?

[pspunlimited]

What is your expected Weeks for Feb 2015 and May 2015?

Weeks 1 - 4 for February and for May Weeks 1 - 5

[:) Sixthsense :)]

Asking the same question asked by nflsales, what is the expected weeks for January 2015?

[pspunlimited]

Asking the same question asked by nflsales, what is the expected weeks for January 2015?

that was just an example you can refer as well to the calendar

[:) Sixthsense :)]

We cannot offer something on assumption and we ask questions to understand to the logic to arrive the result.

So giving proper reply to our question will result as giving exact answer

[pspunlimited]

We cannot offer something on assumption and we ask questions to understand to the logic to arrive the result.

So giving proper reply to our question will result as giving exact answer

Jan Weeks 1 - 5
Feb Weeks 1 - 4
MArch Weeks 1 - 5
Arpril Weeks 1 - 5
May Weeks 1 - 5
June Weeks 1 - 5
July Weeks 1 - 5
August Weeks 1 - 5
SEpt Weeks 1 - 5
Oct Weeks 1 - 5
Nov Weeks 1 - 5
Dec Weeks 1 - 5

[samba_ravi]

Try
F3=IF(B2="February","","Week 5")

[:) Sixthsense :)]

In B3 Cell


=IF(COLUMNS($A:A)<=IF($B$2="February",4,5),"Week "&COLUMNS($A:A),"")


Drag it to right...

[pspunlimited]

In B3 Cell


=IF(COLUMNS($A:A)<=IF($B$2="February",4,5),"Week "&COLUMNS($A:A),"")


Drag it to right...

Oh Nearly Correct.

But I want Include at least 6 rows per column

[:) Sixthsense :)]

But I want Include at least 6 rows per column

Not sure what do you mean with that statement

[pspunlimited]

Not sure what do you mean with that statement

Ex If I choose February It will display Weeks 1 - 4 inlcuding its Rows 1 - 6 per column

[:) Sixthsense :)]

Are you talking about filling the formula down the rows? row 4 row5 row6 also?

[pspunlimited]

Meaning if I put numbers(ex. 1) in B4 - B10, C4 - c10 until F4 - f10, so whatever data I have in January will not be seen in February

[:) Sixthsense :)]

Why don't you use a pre made free template?

Check the attached file