Would like week number 1 to be first week in Jan with a Wednesday

Using weeknum function to number weeks but we use the first week in Jan that has a Wednesday as week 1.  Help on this please.
acdecalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Swapnil NirmalManager, Audit AnalyticsCommented:
Use it like this:

=WEEKNUM(A1,13)
0
Martin LissOlder than dirtCommented:
I found this on the web. It assumes that A1 is January 1st of any year.

=IF(WEEKDAY(A1)<=4,A1+4-WEEKDAY(A1),A1+11-WEEKDAY(A1))
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
acdecalAuthor Commented:
MartinLiss, that would work but now I need a function to produce A1,  Jan 1 of the year I select.  Say I have 2015 in a cell and I want A1 to be 1/1/2015
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Swapnil NirmalManager, Audit AnalyticsCommented:
Say value of B1 is 2015. The formula to be as below:
=DATE(B1,1,1)
0
Martin LissOlder than dirtCommented:
If "2015" is in A2 the put this formula in A1
= "1/1/" & A2
0
barry houdiniCommented:
I see this question has been answered but I'm a little confused - isn't the requirement to get a week number from a date? Martin's solution returns a date, first Wednesday of the year.

btw you can get that more easily with this formula if A1 is 1st Jan date

=A1+7-WEEKDAY(A1+3)

regards, barry
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.