First and Last Date for a given week and year???

  • Thread starter Thread starter Benz
  • Start date Start date
B

Benz

Hello all,
Can anyone please tell me how to find the first and last
date of a week when the year and the week number is given?
The week model followed is the ISO model: Monday is the
1st day of the week and the 1st week should have atleast
4 days.
I got to see one thread on this topic, but it doesnt
work.. there are problems with it when an year has 52 or
53 weeks in it....

Any help would be welcome.

Benz.
 
Benz said:
Hello all,
Can anyone please tell me how to find the first and last
date of a week when the year and the week number is given?
The week model followed is the ISO model: Monday is the
1st day of the week and the 1st week should have atleast
4 days.
I got to see one thread on this topic, but it doesnt
work.. there are problems with it when an year has 52 or
53 weeks in it....

Any help would be welcome.

Benz.
Click to expand...
 
You must log in or register to reply here.

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

Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
payroll weeks / varying first day and week of the year 2
Week Number Format 4
weekday last year 2
Week of year 1
function for date of first and last day through weeknumber 1
Year + week => first date of week 9
Fiscal Year Week Number Calculation with a twist.... 6

Back
Top