Calculate the difference between two dates
I have a formula numeric field (called Duration) where I'd like to show in days (excluding weekends) the difference between the start date (date field) and end date (date field). I'm using the follow...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this
ToDays([end date]-[start date])
You may need to do
ToDays([end date]-[start date]) + 1
if you want to count both the start and end days as days.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ToDays([end date]-[start date])
You may need to do
ToDays([end date]-[start date]) + 1
if you want to count both the start and end days as days.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------