View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] NoSpam@aol.com is offline
external usenet poster
 
Posts: 142
Default Week Number Function

On Wed, 15 Mar 2006 09:36:58 -0600, gti_jobert
wrote:


Hi all,

I am trying to calculate the week number on a given date. The following
function I obtained from the net;

How do you define week number? For example, Jan 1, 2003 was on Wednesday.
In 2003 is the first day of week 2:
Wednesday Jan 8, or
Sunday Jan 5?