MainScienceReferenceStandards › Week Numbers In Excel

Week Numbers In Excel

Edit Page
Report
Scan day: 05 March 2014 UTC
10
Virus safety - good
Description: How to calculate absolute week numbers, Excel week numbers and ISO week numbers (with Formula and VBA). Links to other ISO 8601 related materials.
This page has been replaced. Please see Some business applications use week numbers to categorize dates.  For example, a business may report sales amounts by week, and identify each period as "9912", representing the 12th week of 1999.  While this may be convenient in some applications, you need to be careful when using week numbers.   When does week 1 start? On the first day of the year? As the first full 7 day week of the year? The first week having more than 3 days?  Moreover, what day does a week begin on?  Sunday or Monday? 
Size: 545 chars

Contact Information

Email:
Phone&Fax:
Address:
Extended:

WEBSITE Info

Page title:Week Numbers In Excel
Keywords:Excel, Microsoft Excel, VBA, Excel97, Excel2000, Excel Formulas, Excel Macros, Excel Functions
Description:Working with Week Numbers In Microsoft Excel97 and 2000. Includes both worksheet formulas and VBA code procedures.
IP-address:69.24.78.105

WHOIS Info

NS
Name Server: NS1.GEARHOST.COM
Name Server: NS2.GEARHOST.COM
WHOIS
Status: ok
Date
Creation Date: 22-jun-1999
Expiration Date: 22-jun-2014