Date of Sunday for Week Number and Year

[jrp]

Seems like this should be simple, but I'm stumped. I have the Week of Year (44), and the Year (2003), and I would like to calculate the date of the Sunday of that week (10/26/03).

Possible?

Many thanks in advance.

[BobWeaver]

Date(1,(Weekofyear-1)*7,Year)-DayofWeek( Date(1,1,Year))+2

I haven't given this a thorough test. but if it works for weeks 1, 52 and 53 for seven consecutive years, it should work for everything.

[Ugo DI LUCA]

Try this :

WeekOfYear * 7 + Date(1, 1, Year) - DayOfWeek(Date(1, 1, Year))-6

[Ugo DI LUCA]

You beat me to this Bob

Was testing it and chatting a lot. Now, I've tested both and both are working.

[jrp]

Dang, I wish my brain worked like that.

Thank you both!