Calculate the difference between two dates

Question

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 following formula, but the number in the Duration field is not right (([End Date:] - [Start Date:]) / Days(30)).

Please let me know what am I doing wrong.

Thank you!

-g

------------------------------
Gwen Peters
------------------------------

MarkShnierYou · Answer

Try thisToDays([end date]-[start date])You may need to do ToDays([end date]-[start date]) + 1if you want to count both the start and end days as days.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community