Forum Discussion

AlycnBjergo-Jus's avatar
AlycnBjergo-Jus
Qrew Member
5 years ago

Duration

How can I take a Date field and subtract the current (today) date from it to count how many days have past in a formula?

------------------------------
Alycn Bjergo-Justen
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    Today is represented in formulas as Today(). For something like this, you'd just need to subtract one value from another.

    [Date] - Today()

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • AlycnBjergo-Jus's avatar
      AlycnBjergo-Jus
      Qrew Member
      5 years ago
      Thank you, how to I then take this duration of days and have it exclude weekends in the count?

      [EstDelDate]-Today()

      ------------------------------
      Alycn Bjergo-Justen
      ------------------------------