If you use my Generic Excel Calendar at

http://www.ProbabilityOf.com/excel.shtml



You can use the UDF: =DateToWeek(A1), =NorskHelligdagSant(A1;1;1) and
=NorskHelligdagdesc(A1;1;1) in the sheet Excel_Calendar.xls. It may be
wise to adjust the text and non working days to your country (should be
self explaining if you can UDF)

Make a list with all the dates (SANN = TRUE, USANN = FALSE) like:

Date ISOWeek
=DateToWeek(A1) =NorskHelligdagSant(A1;1;1) =NorskHelligdagdesc(A1;1;1)
2005-01-01 2004-W53-6 SANN 1. nyttårsdag
2005-01-02 2004-W53-7 SANN søndag
2005-01-03 2005-W01-1 USANN
2005-01-04 2005-W01-2 USANN
2005-01-05 2005-W01-3 USANN
2005-01-06 2005-W01-4 USANN
2005-01-07 2005-W01-5 USANN
2005-01-08 2005-W01-6 SANN lørdag
2005-01-09 2005-W01-7 SANN søndag
2005-01-10 2005-W02-1 USANN
2005-01-11 2005-W02-2 USANN

2005-03-12 2005-W10-6 SANN lørdag
2005-03-13 2005-W10-7 SANN søndag
2005-03-14 2005-W11-1 USANN
2005-03-15 2005-W11-2 USANN
2005-03-16 2005-W11-3 USANN
2005-03-17 2005-W11-4 USANN
2005-03-18 2005-W11-5 USANN
2005-03-19 2005-W11-6 SANN lørdag
2005-03-20 2005-W11-7 SANN søndag
2005-03-21 2005-W12-1 USANN
2005-03-22 2005-W12-2 USANN
2005-03-23 2005-W12-3 USANN
2005-03-24 2005-W12-4 SANN Skjærtorsdag
2005-03-25 2005-W12-5 SANN Langfredag
2005-03-26 2005-W12-6 SANN lørdag
2005-03-27 2005-W12-7 SANN 1. påskedag
2005-03-28 2005-W13-1 SANN 2. påskedag
2005-03-29 2005-W13-2 USANN
2005-03-30 2005-W13-3 USANN
2005-03-31 2005-W13-4 USANN
2005-04-01 2005-W13-5 USANN
2005-04-02 2005-W13-6 SANN lørdag
2005-04-03 2005-W13-7 SANN søndag