Find date from year and week number
How to find exact date from year and week number.
I have googled and found many formulas but none of them is working correctly.
One of them was as below.
Formula:
Please Login or Register to view this content.
A1=nth Day
B1=Week no
C1=Year
E1=FORMULA/Date
Last edited by pnperl; 07-17-2014 at 01:58 AM. Reason: File corrected
I thing wrong file is uploaded.
Did you attach the wrong file?
Anyway - to return the first Sunday of the Week, based on year and week number, try:
Formula:Please Login or Register to view this content.
Adjust references myYear and myWeek to suit. Amend the final 6 to change which weekday is returned.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
File corrected.
Week starts with Monday.Originally Posted by Olly
Did you attach the wrong file?
Anyway - to return the first Sunday of the Week, based on year and week number, try:
Formula:Please Login or Register to view this content.
Adjust references myYear and myWeek to suit. Amend the final 6 to change which weekday is returned.
Anyway, if you check with this formula, it fails.
Can it be modified to give nth day?
What do you mean, "it fails" ? It works here...
As I said, to change which weekday is returned, change the final number. So, to return Monday of Week 12, use:Formula:Please Login or Register to view this content.
Values in red are the varaiables to change for different years / weeks / days.
Re: Find date from year and week number
Thanks for reply, but finally I have modified formula to get it worked,What do you mean, "it fails" ? It works here...
As I said, to change which weekday is returned, change the final number. So, to return Monday of Week 12, use:Formula:Please Login or Register to view this content.
Values in red are the varaiables to change for different years / weeks / days.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks