Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi Soren

See also
http://www.erlandsendata.no/english/...dateweeknumber
and
http://www.cpearson.com/excel/weeknum.htm

If you want to play with this yourself, one good approach is that January
4th is always in week 1.

HTH. Best wishes Harald

"soren" skrev i melding
...
I am working with week numbers and need Excel to accept as week 1 the

first
week of the year with 4 or more days. I.e. week starting Monday 3rd

January
2005 should be reflected as week 1.

The program reflects this week as week 2 by default. How to change this?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line or bar graphs for tracking stocks profit and loss. Mocity Charts and Charting in Excel 1 January 21st 05 01:21 AM
I need week number in excell from a date, first week must be mini. jPeich Excel Discussion (Misc queries) 4 January 5th 05 01:21 AM
Format an excel column as a date for a 5 day week for a year. dabenesch Excel Discussion (Misc queries) 1 December 30th 04 02:45 PM
Weeknum Year by Year Compare RJB Charts and Charting in Excel 4 December 29th 04 10:33 PM
How do I annualize a standard deviation NIKU Excel Discussion (Misc queries) 3 December 13th 04 12:06 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"