How can I insert the dates of the week based on the week numbers (starting on sunday).
G Gertjan Nov 10, 2003 #1 How can I insert the dates of the week based on the week numbers (starting on sunday).
J J.E. McGimpsey Nov 10, 2003 #2 one way: Assume the week number is in A1, and week 1 starts on the first Sunday of the year: B1: =DATE(YEAR(TODAY()),1,7*A1-WEEKDAY(DATE(YEAR(TODAY()),1,1),3)) but also see: http://cpearson.com/excel/weeknum.htm
one way: Assume the week number is in A1, and week 1 starts on the first Sunday of the year: B1: =DATE(YEAR(TODAY()),1,7*A1-WEEKDAY(DATE(YEAR(TODAY()),1,1),3)) but also see: http://cpearson.com/excel/weeknum.htm
