Week No Q

S

Seanie

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top