![]() ![]() Week 52 (2016) Sunday 19th June - Saturday 25th June. In the meantime I will read the article for the posted link. I agree with DavidK that the formula to convert Weeknrs into dates works for 2015, but not for 2016 (as week 1 starts on 4th of January). So this would give you the right result for: Week 1 (2017) Sunday 26th June - Saturday 2nd July. I hope my clarification makes it possible to receive more suggestions, because I do appreciate them and I apologize for not defining the Excel version! Perhaps if I could relate to what's happening while evaluating the expression I could figure out how to effect the shift for a Friday start but it's a bit over-whelming. You get dates like 2014-52 for week -52 where it was week 1 before. Find more info on our main week number page. Like in the chart below, when i see with all the date, the week of should be the week 53, but here it show 44, and there is no first week of 2016. I first tried changing the date format in the Access Query to this: OrderWeek: Format ( OrderDate,'yyyy-ww',1,3) <- But it did not do the trick. Find the ordinal day number first: moy 11 dom 5 leap 1 add 305, from table lookup doy. Please note that there are multiple systems for week numbering, this is the ISO week date standard (ISO-8601), other systems use weeks starting on Sunday (US) or Saturday (Islamic). Find the week number of Saturday 5th November 2016 (leap year). For those of you who think the examples I gave are incorrect, it may be difficult to visualize such a calendar but I have a hard copy of it and am pretty sure I got it right.Īny expression suggested here that uses 15 (A2,15) causes the #NUM! error, likely because I failed to note in my profile that the Excel version is 2007. All weeks are starting on Monday and ending on Sunday. If not doable, they will have to create a lookup table. Not sure if the reason for this is payroll or planned maintenance related, I'm just trying to solve a problem for a work colleague. I realize the ISO standard does not start on Friday but I'm trying to base the result on a calendar wherein the first week of the year does have at least 4 days in it, and starts on a Friday. I meant I need the first week that has 4 days in it like the European (ISO) standard does, to be week 1, but based on a Friday start, the first day would have to be no later than Monday in order to achieve this. I mislead some of you a bit - my apologies. Need the European standard for the first day of a week that has 4 days in it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |