Find date from week/month/year

[cfer]

Hi,

I am trying to get the Sunday date from the following

Cell E5 has the week number, 3.

I am using week 1 represents the first 7 days, week 2 represents the 2nd week, week 3 = the third week,4th = fouth week, etc for each of the months.

H5 has the Month

M5 has the year.

the result I am after is 13/02/2011.

I have had a search, but can only find it going the other way.

Thanks in advance

Cfer

 

[Canapone]

Hi,

I'm sure there are better solutions.

=DATE(M5,H5,1)+7*(E5)-WEEKDAY(DATE(M5,H5,1),2)

Regards

 

[cfer]

Hi Canapone,

Thank you

Cfer