![]() |
Calendar Template with week numbers
Hi
I am looking for a calendar template that has a column with week numbers. It should also include the dates associated with that week in the other columns. Thanks Deej -- |
Calendar Template with week numbers
Deej,
Start from A2, with the numbers 1, 2, etc downwards, until 53. Start from B1, with the numbers 1-7 to the right. These stand for Sunday through Saturday. In B2 use the formula: =DATE(YEAR(TODAY()),1,($A2-1)*7+B$1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),1)+1 This will work for the current year. If you need other years, enter the year in a separate cell, e.g K1, and substitute $K$1 for the expression YEAR(TODAY()) wherever necessary. HTH Kostis Vezerides |
All times are GMT +1. The time now is 05:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com