Forum Discussion

Qrew Member

4 years ago

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...

Formulas and functions

MarkShnier__You

Qrew Champion

Try 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
------------------------------