Find week no from month..

[MohitMathur1234]

Hello ,

I have data where in one column have Month Like "Oct, Nov,Dec" and one column Have Week no.s Like "44,45,46,47".
And I have 2 cells where i want to select month "nov" from drop down and from another cell select "week1"(here week 1 is for week 45 of nov,week 2 is fr week 46 etc) from drop down. So data will fetch of nov and week from 45 to 48.
Please solve asap.

Data should be like :-
Week number Month
Week 01 Dec
Week 02 Jan
Week 03 Jan
Week 04 Jan
Week 05 Jan
Week 06 Feb
Week 07 Feb
Week 08 Feb
Week 09 Feb
Week 10 Mar
Week 11 Mar
Week 12 Mar
Week 13 Mar
Week 14 Mar
Week 15 Apr
Week 16 Apr
Week 17 Apr
Week 18 Apr
Week 19 May
Week 20 May
Week 21 May
Week 22 May
Week 23 Jun
Week 24 Jun
Week 25 Jun
Week 26 Jun
Week 27 Jun
Week 28 Jul
Week 29 Jul
Week 30 Jul
Week 31 Jul
Week 32 Aug
Week 33 Aug
Week 34 Aug
Week 35 Aug
Week 36 Sep
Week 37 Sep
Week 38 Sep
Week 39 Sep
Week 40 Sep
Week 41 Oct
Week 42 Oct
Week 43 Oct
Week 44 Oct
Week 45 Nov
Week 46 Nov
Week 47 Nov
Week 48 Nov
Week 49 Dec
Week 50 Dec
Week 51 Dec
Week 52 Dec

 

[Somendra Misra]

Hi Mohit,

Consider uploading a file.

Edit: See this file, or else upload a sample file.

Regards,

 

[MohitMathur1234]

Superb..!!
Thank you so much.. for the quick reply..