Week No Q
 

How could I return the week number that equates to a particular date?

I have tried =weekno(a1), but firstly my weeks begin on a Monday, not
Sunday and secondly I want to express a fraction of a week also

For example
10/11/08 = 46.00
11/11/08 = 46.14
12/11/08 = 46.29 etc etc
17/11/08 = 47.00
18/11/08 = 47.14 etc etc

Week No Q
 

Try this

=(A1-DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,3)+WEEKDAY(DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,3))+5)/7

Mike

"Seanie" wrote:

How could I return the week number that equates to a particular date?

I have tried =weekno(a1), but firstly my weeks begin on a Monday, not
Sunday and secondly I want to express a fraction of a week also

For example
10/11/08 = 46.00
11/11/08 = 46.14
12/11/08 = 46.29 etc etc
17/11/08 = 47.00
18/11/08 = 47.14 etc etc

Week No Q
 

=ROUND(WEEKNUM(A2,2)+(WEEKDAY(A2,2)-1)/7,2)

--
__________________________________
HTH

Bob

"Seanie" wrote in message
...
How could I return the week number that equates to a particular date?

I have tried =weekno(a1), but firstly my weeks begin on a Monday, not
Sunday and secondly I want to express a fraction of a week also

For example
10/11/08 = 46.00
11/11/08 = 46.14
12/11/08 = 46.29 etc etc
17/11/08 = 47.00
18/11/08 = 47.14 etc etc

Week No Q
 

Thanks Guys