Prompt to calculate the date formula

[bsnapool]

Hi All

Come stuck on a macro. Wondering whether some one could help?

I would like the macro to work out the week end sunday when a week of the year is entered.

E.g. if week 27 is entered into a cell, this would then calculate and enter the weekend sunday date in a selected cell.

Hope this makes sense.

Thanks Andrew

[starryknight64]

I'm sorry Andrew, but this does not.

What is "weekend Sunday date"?