Converting date to week number over several years

S

spudsnruf

Hi,

I understand how to use the weeknum() function to conert a date to a week
number, but this is only useful if need to convert 1 year. What should I do
to convert 4 consecutive years to a week number, so all weeks numbers are not
the same. e.g I want to make January 1st 2006 as week '1' and January 1st
2007 '53' instead of 1 again. Thanks very much.
 
J

Jacob Skaria

With the date in A1
=ROUNDUP(DATEDIF(DATE(2006,1,0),A1,"d")/7,0)

If this post helps click Yes
 
S

spudsnruf

Absolute genius. Works perfectly. saved me hours and hours. Thanks a million.
 

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

Similar Threads

Is 4th January 2010 = Week 2?? 5
Week Number Format 4
2010-01-04 is equal to week 2??? 1
Current year and current week number 9
comparable week numbers overs years 1
Show week number in current month 4
calculate week difference 2
How to format a cell from date to week? 2

Top