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

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

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *