Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week

Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week

 

Use the DATE and WEEKDAY functions as shown in the following formula:

=DATE(C2,1,3)-WEEKDAY(DATE(C2,1,3),1)+7*(B2-1)+A2