Week numbers

[Olan]

Is it possible to show week numbers in the availability calendar?

Olan

[marco]

Sorry, it's not. Numbers relative to year or month? Is there any special reason that you need them for?

Marco

[Olan]

Sorry, it's not. Numbers relative to year or month?

Don't no what you mean by that, please explain.


Here in Holland we use often weeknumbers for planning the vacation.

Greets,

Olan

[marco]

Hello Olan,
So I imagine you're interested in the "4th week of 2008", not "4th week of July".

Marco

[jwilmes]

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:

Code: Select all

=TRUNC(((B6-DATE(YEAR(B6),1,0))+6)/7)

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.