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.

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.

Try this :

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

You beat me to this Bob

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

Dang, I wish my brain worked like that.

Thank you both!