Calculate date from week #

[bb84604]

I'm trying to figure out how to calculate a date from a week #.

I have a simple calendar that I can switch from one week to the next. So if I am on week 14 I want it to calculate the date of Monday on that week (3/28/2005).

Thanks,

[comment]

Assuming your week# is the same as Filemaker's WeekOfYear, and that it refers to the current year, the date of Monday is:

Date ( 1 , 1 , Year ( Status (CurrentDate) ) )

- DayOfWeek ( Date ( 1 , 1 , Year ( Status (CurrentDate) ) ) )

+ 7 * ( week - 1 ) + 2

[bb84604]

Thanks, that worked. Only problem is I don't understand exactly how it worked.

Is there any chance you could just line item what it is doing in lay terms?

Thanks so much.

[comment]

// THE DATE OF NEW YEAR

Date ( 1 , 1 , Year ( Status (CurrentDate) )

// MINUS THE DAY OF WEEK OF NEW YEAR

- DayOfWeek ( Date ( 1 , 1 , Year ( Status (CurrentDate) ) ) )

// IS THE SATURDAY BEFORE NEW YEAR

+ 7 * ( week - 1 )

// IS THE SATURDAY BEFORE THIS WEEK

+ 2

// IS THE MONDAY THIS WEEK

[bb84604]

Awesome. Thank you.

Sorry I'm so thick today, I should have known that.