Excel date to week number2/24/2023 ![]() ![]() The first part "DATE(B1,1,1)+(B2×7)" simply takes January 1 of the year and adds the number of weeks. I'm sorry folks, but I could neither understand nor make work any of the formulas above so I finally figured out the following solution:ĭATE(B1,1,1)+($A4×7)−(6−(7−WEEKDAY(DATE(B1,1,1),first-day))) Easy deploying in your enterprise or organization.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |