View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NorTor[_4_] NorTor[_4_] is offline
external usenet poster
 
Posts: 8
Default 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