Is it possible to show week numbers in the availability calendar?
Olan
Week numbers
Moderator: marco
Olan
I think the information needed is as the number of the week in the year. I have added the code for Excel to calculate this number. It is a standard way of communicating a particular week.
I have had the same question.
Olan, can we share experiences directly?
Jeroen
------------------------------------------
Absolute Week Numbers
An absolute week number is the 7 day period that a date falls within, based solely on the first day of the year, regardless of the day of the week. Week 1 is always Jan-1 to Jan-7, week 2 is always Jan-8 to Jan-14, and so on. If the year begins on a Thursday, then each "week" is from Thursday to the following Wednesday. The absolute week number will always be between 1 and 53. Week 53 will have either one or two days, depending on whether the year is a leap year. If the year is a not a leap year, week 53 will consist of one day: Dec-31. If the year is a leap year, week 53 will consist of two days: Dec-30 and Dec-31.
Given a date in cell A1, you can determine the absolute week number with the following formula:
For example, if A1 contains the date 2000-June-21, the formula will return 25. Since the year 2000 began on a Saturday, the 25th week runs from Saturday, 2000-June-17, to Friday, 2000-June-23.
I have had the same question.
Olan, can we share experiences directly?
Jeroen
------------------------------------------
Absolute Week Numbers
An absolute week number is the 7 day period that a date falls within, based solely on the first day of the year, regardless of the day of the week. Week 1 is always Jan-1 to Jan-7, week 2 is always Jan-8 to Jan-14, and so on. If the year begins on a Thursday, then each "week" is from Thursday to the following Wednesday. The absolute week number will always be between 1 and 53. Week 53 will have either one or two days, depending on whether the year is a leap year. If the year is a not a leap year, week 53 will consist of one day: Dec-31. If the year is a leap year, week 53 will consist of two days: Dec-30 and Dec-31.
Given a date in cell A1, you can determine the absolute week number with the following formula:
Code: Select all
=TRUNC(((B6-DATE(YEAR(B6),1,0))+6)/7)