Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 -- |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas to numbers | New Users to Excel | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Template in Excel | New Users to Excel | |||
need to make a template for weekly calendar ASAP that shows pictu. | Excel Discussion (Misc queries) | |||
first week of year - according to european standard | Excel Worksheet Functions |