Posted inResources Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week Table of Contents Toggle Excel Tips: Calculating a Date Based on Year, Week Number and Day of the WeekRelated 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 Related Related posts: Excel Tips: Selecting a random value from a List. Excel tips: Finding the Last Day of a Given Month Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year. Favorite WordPress Plugin – Google XML Sitemaps Post navigation Previous Post Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year.Next PostInterpersonal Skills that must need for Life
