Weeknumber of calendar date?
Hello,
I need to insert a temperature to a sheet, based on a table stating
expected temperatur on a given week number.
Problem is, I now only have exact calendar days for the comparison, so
I need to find a way using VBA to calculate the week number for a
future calendar date (eg 15th October 2008 - what week number of the
year is this?).
I have still not found a way to do this - help very much appreciated.
Regards,
Tor O
Aalesund, Norway
|