Calculating Date Range for Weeks


#1

How can I calculate the first and last day of a week, for example in 2019, week 6 would be 2/03/19 and the last day would be 2/09/19.


#2

To calculate the first day of weekNumber in yearNumber, use this formula:

week1st(year1st(datevalue(yearNumber,1,1))+weekNumber*7)

To calculate the last day of the same week, just add 6 to this value.

This is going to be a bit tricky around the beginning and end of the year, since I’m not sure what your goal is, I’ll just leave that detail to you. Also, is the first week zero, or 1? My formula actually calculates the first day of week 6 as 2/10/19 instead of 2/3/19. So you’ll need to adjust for your actual application.


#3

Works wonderful. Thank you Jim.