• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change month into week number

B

BiGMo

New Member
Hi there,

I need your help guys can’t find a solution for my problem:

Example:

In A2 is a dropdown January-December
In B3,B4,B5,B6 should be the week of the selected Month form A2, it should change by changing the selected month

Check the file may be you have a solution for my problem :)

Sorry for my bad English

Kind regards
 
Just for basic purpose...
you can use in B3..

=WEEKNUM(1&A2)

In case if its working.. you can avoid.. checking # of weeks in the month.. irrespective of 4 or 5.. and week should be start from 1st monday..

Let us know if you want..

BTW.. in c3, d3, you can just add B3+1.
 
Debraj said:
Just for basic purpose...
you can use in B3..

=WEEKNUM(1&A2)

In case if its working.. you can avoid.. checking # of weeks in the month.. irrespective of 4 or 5.. and week should be start from 1st monday..

Let us know if you want..

BTW.. in c3, d3, you can just add B3+1.
Click to expand...

Honestly you are the best it its working fine thank you so much
 
You must log in or register to reply here.
Back
Top