Calendar Template with week numbers

D

Deej

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

vezerid

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
 
Top