Posted inResources

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

 

This post is authored by Khan Mohammad Mahmud Hasan, a Education and Career expert with 20+ years in curriculum design, teacher training, and career coaching. Contact him via WhatsApp at +8801714087897 or explore other methods on the contact page. 

Join my WhatsApp Group for more updates 

Related posts:

Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year. Excel tips: Finding the Last Day of a Given Month Excel Tips: Selecting a random value from a List. Excel tips: How to Locate Merged Cells in Microsoft Excel (and then get rid of it)
Tags: