software

Hello,
What formula can convert a week number to the Sunday's date for the week
number listed. Example:
Year WeekNumber Formula Result
2006 3 Jan 15,2006
2005 51 Dec 18,2005
I have searched and still can't find the solution.
Thanks you very much for your help!
Terri
If year is in A1 and week number in B1

=DATE(A1,1,1)-WEEKDAY(DATE(A1,1,7)) B1*7--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=526843Terri --
If Year is Column A, Wk# is Column B, Result is Column C, then this works in
Column D =

=IF(WEEKDAY(C2)gt;1,C2-(WEEKDAY(C2)-1),C2)

It says, quot;Take the day of the week of the formula result. If it's anything
other than a '1' (the first day of the week), subtract one less than that
number to get back to Sunday of that week. If it already is Sunday, just
leave it alone.quot;

It's kind of brute force, but it works. Maybe someone else can be a bit
more elegant.

HTH

quot;Terriquot; wrote:

gt; Hello,
gt; What formula can convert a week number to the Sunday's date for the week
gt; number listed. Example:
gt; Year WeekNumber Formula Result
gt; 2006 3 Jan 15,2006
gt; 2005 51 Dec 18,2005
gt; I have searched and still can't find the solution.
gt; Thanks you very much for your help!
gt; Terri
gt;

Wow!! Works great!
Thank You!

quot;daddylonglegsquot; wrote:

gt;
gt; If year is in A1 and week number in B1
gt;
gt; =DATE(A1,1,1)-WEEKDAY(DATE(A1,1,7)) B1*7
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=526843
gt;
gt;