Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 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 DATE] = 11/4/2022
etc...
thank you

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

4 Replies

Sort By
  • DanaHauser's avatar
    DanaHauser
    Qrew Cadet
    2 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
      2 years ago
      Well, now that was easy.  Thank you!

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

        ------------------------------
        Dana Hauser
        ------------------------------
    • SimonH's avatar
      SimonH
      Qrew Cadet
      2 years ago
      Keep 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
      ------------------------------