ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calendar Template with week numbers (https://www.excelbanter.com/excel-discussion-misc-queries/51928-calendar-template-week-numbers.html)

Deej

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
--



vezerid

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