Hi all,
How to extract date ex. first day of week based on week number and year.
Example
week: 30
year: 2020
Result: 20-07-2020
Hi all,
How to extract date ex. first day of week based on week number and year.
Example
week: 30
year: 2020
Result: 20-07-2020
Try this;
Please Login or Register to view this content.
Hi
Another option as a formula
Formula:Please Login or Register to view this content.
or its VBA UDF equivalent with Week in A1 and Year in B1
Then the UDF function in ExcelPlease Login or Register to view this content.
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thanks for help. Haluk solution is enough for me
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks