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 -----------------------...
Forum Discussion
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/
------------------------------
[Date] - Today()
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Thank you, how to I then take this duration of days and have it exclude weekends in the count?
[EstDelDate]-Today()
------------------------------
Alycn Bjergo-Justen
------------------------------
[EstDelDate]-Today()
------------------------------
Alycn Bjergo-Justen
------------------------------