Hello,

I'm trying to find a way to have a range of dates from Monday through Sunday display as the week ending date on Sunday.

For example -- today is 11/29/2010, I can use WEEKNUM(A1,2) and get week 49 but I'd like that to show as 12/5/2010.

Thanks for your help!

Mike