Tip Printed from ExcelTip.com

---

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


Problem:

Calculating a date using the relevant numbers for day of the week, week number, and year number.

Solution:

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