Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 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
3 years ago
If your weekday starts on Sunday, you would use a formula like this: 

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

------------------------------
Dana Hauser
------------------------------
BuildPro's avatar
BuildPro
Qrew Captain
3 years ago
Well, now that was easy.  Thank you!

------------------------------
BuildPro
------------------------------
  • DanaHauser's avatar
    DanaHauser
    Qrew Cadet
    3 years ago
    Glad to help

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