Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Earliest date using WEEKNUMBER | Excel Worksheet Functions | |||
convert date (YYYYMMDD) to weeknumber | Excel Worksheet Functions | |||
Calculate a date based on a weeknumber | Excel Discussion (Misc queries) | |||
Calculate a date based on a weeknumber | Excel Worksheet Functions | |||
Change In Date Format to weeknumber automatically | Excel Programming |