User profile

Status:
Name: Adam Brownsea
Nickname: FB_891725656
Member since: 2009-06-16 01:17:37
Website URL: http://www.facebook.com/profile.php?id=891725656
About me:

Facebook profile
 

User comments

Calculating The Week Number In Excel

July 2nd, 2009 at 5:13 PM

Angus,

I did some tests and your initial findings may have been incorrect. The correct format for WEEKNUM is to include a full date in the first field.

Therefore the following
=WEEKNUM(DATE(2009,07,01),1)
=WEEKNUM(DATE(2009,07,01),2)
return the same result.

Calculating The Week Number In Excel

July 2nd, 2009 at 4:45 PM

Actually it does. If the week begins on a Monday, the week with 1st of Jan would be week one, containing 4 days from January with Thu, Fri, Sat and Sun.

Calculating The Week Number In Excel

July 2nd, 2009 at 4:36 PM

I was interested to read what week the 31st of Dec and 1st of January fall into.

Seems the European standard is Week 1 starts with the first week with 4+ days within. If using the Sunday rule, the week containing the 1st of Jan this year was a Thursday meaning that week only had Thur, Fri and Sat, therefore not matching the 4+ rule, so becomes week 53 of 2008. The first week would began on Sunday 4th of Jan.

Lifehacker's Firefox Add-On Packs

June 16th, 2009 at 11:30 AM

The primary type of add-on missing is a mouse gesture type tool. I can’t live without FireGestures myself.