CODEWITHSUNDEEP
excelexcel-formula
Paul
Paul

Reputation: 69

Excel formula to increase month by one and week in month by one

I need a formula to increase the week in month by one as well as increase the month by one.

Basically I need an ongoing list of Mondays that would follow this pattern:

Month 1 2016, Week 1 2016, Monday = 4th Jan 2016
Month 2 2016, Week 2 2016, Monday = 8th Feb 2016
Month 3 2016, Week 3 2016, Monday = 21st Mar 2016
Month 4 2016, Week 4 2016, Monday = 25th Apr 2016
Month 5 2016, Week 1 2016, Monday = 2nd May 2016
Month 6 2016, Week 2 2016, Monday = 13th Jun 2016

Upvotes: 0

Views: 174

Answers (1)

PaichengWu
PaichengWu

Reputation: 2689

as below 

month   date_of_first_Monday                         how_many_Mondays                                               Ith_Monday_request                       the_date_request
1/1     =Choose(Weekday(A2,2),0,6,5,4,3,2,1)+A2      =roundup((day(eomonth(a2,0))-weekday(eomonth(a2,0),3))/7,0)    =if(month(a2)=1,1,if(d1+1>c2,1,d1+1))    =b2+7*(d2-1)
2/1        
3/1

enter image description here

Upvotes: 1

Related Questions