Forum Discussion
4 Replies
Sort By
- DanaHauserQrew CadetIf your weekday starts on Sunday, you would use a formula like this:
FirstDayOfWeek([Actual Finish Date])+Days(5)
------------------------------
Dana Hauser
------------------------------- BuildProQrew CaptainWell, now that was easy. Thank you!
------------------------------
BuildPro
------------------------------- DanaHauserQrew CadetGlad to help
------------------------------
Dana Hauser
------------------------------
- SimonHQrew CadetKeep in mind that this formula will return the current Friday even if the completion date is that same Friday, or even Saturday for that matter.
If these edge cases are of no concern then you can use the formula as is.
Otherwise you want to add 1 (for Saturday) or 2 (for Friday) days to the finish date before calculating the week start so that it gets pushed into the next week
FirstDayOfWeek([Actual Finish Date]+Days( "1 or 2" ))+Days(5)
------------------------------
Simon H
------------------------------