Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
4 years ago

Need Formula to fill field with current Friday

[ACTUAL FINISH] = any day within the week, then [BILLED DATE] will = that week's Friday date For Example [ACTUAL FINISH] =11/1/22, [BILLED DATE] = 11/4/2022 [ACTUAL FINISH] =11/3/22, [BILLED DAT...
DanaHauser's avatar
DanaHauser
Qrew Cadet
4 years ago
If your weekday starts on Sunday, you would use a formula like this: 

FirstDayOfWeek([Actual Finish Date])+Days(5)

------------------------------
Dana Hauser
------------------------------