Skip to main content
Question

Need Formula to fill field with current Friday

  • November 1, 2022
  • 0 replies
  • 30 views
Forum|alt.badge.img+11
[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 DATE] = 11/4/2022
etc...
thank you

------------------------------
BuildPro
------------------------------

    • DanaHauser
    • Registered
    • November 1, 2022
    If your weekday starts on Sunday, you would use a formula like this: 

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

    ------------------------------
    Dana Hauser
    ------------------------------
    Terms & ConditionsAccessibility statement