Search results

Hi Sir JB7, Thank you for the new formula. Unfortunately, 21 as the 2nd parameter does not work on older versions of Excel (before Excel 2010). Hopefully, there will be a solution for that soon. Thank you for all the help. JJ

Hi SirJB, Thank you for the new formula, however, there seems to be a problem. With the European System most years should only have 52 weeks (2012 has 52 weeks, 2013 has 52 weeks etc.). Furthermore, with the formula that you posted earlier the following happens: Week Year Add Weeks New...

Hi SirJB7, I don't know which formula to use to get the European System. Is there a way of changing to the european system on Excel or do you know a formula that I could use? JJ

Hi SirJB7, I have understood your explanation of the week numbers. If we use the European System there will only be 52 or 53 weeks in the year. I need to use the European Sytem: - week starts on a Monday - week 1, should have the 'majority of days of the week' should be from January (as...

Hi, I am still having problems with the week numbers. I read this about the weeknum function:  "The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of...

Thank you for your tips. There seems to be a problem with the week numbers. Example: Subtract 22 weeks from week 22 year 2013. The answer is week 54 year 2012. (22/2013 – 22 weeks =54/2012) There are definitely not 54 weeks in a year. How can I solve this problem? I would like to keep...

Hi! I am Jejo, student looking for cool ways to improve my excel skills. I am based in Germany. JJ

Hi SirJB7! Thank you that was very helpful. JJ

I would like to find a formula to add (or subtract) week numbers. Example: Add 8 weeks to week 50 in year 2012. The answer should be week 6, year 2013 50/2012 + 8 weeks = 6/2013 Add 100 weeks to week 50 in year 2012. The answer should be week 46, year 2014. 50/2012 + 100 weeks = 46/2014...