How to convert week of month into Date?

[Shermaine2010]

Rules: Monday as the 1st day of month.


2rd week of July 2015= 13.07.2015

3rd week of Aug 2015 = 17.08.2015.

What is the formulas to get the exact date from the week of month?

Thanks

[azumi]

Perhaps :

=DATE(C2,MONTH(B2&1),1)+7*(A2)-WEEKDAY(DATE(C2,MONTH(B2&1),1),3)

C2=Year
B2 = Month (text formatted example July)
A2 = Week Number

Hope this works

[Shermaine2010]

Great.. Thanks

[azumi]

You're welcome, and thanks for feedback

[daddylonglegs]

=DATE(C2,MONTH(B2&1),1)+7*(A2)-WEEKDAY(DATE(C2,MONTH(B2&1),1),3)

Does that work when 1st of the month is a Monday? For example for June 2015 I'd expect week 1 to be Monday 1st June 2015....but that formula gives 8th June. You can amend like this to get the correct date in all circumstances

=DATE(C2,MONTH(B2&1),0)+7*(A2)-WEEKDAY(DATE(C2,MONTH(B2&1),0),3)

.....or this version also works for me

=(1&B2&C2)-WEEKDAY(6&B2&C2)+A2*7

format result cell as date