We have a base that has start date and end date columns. Need a formula that counts how many days worked in the month on that project. Anyone done this before?
Looking for a formula to count days worked on a project.
There's DATETIME_DIFF function and WORKDAY_DIFF function available
+12Hi @Kelsey123, wondering if you could provide a little more context on how the data would be interpreted. Given the "in the month" requirement, this might be more complex than a single formula field. In the meantime, providing some options below:
Standard formula for counting days between the start/end date:
DATETIME_DIFF({End Date}, {Start Date}, 'days')
If you want to count workdays only, it would use a different operator and the order of the start/end dates would be reversed:
WORKDAY_DIFF({Start Date}, {End Date})
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.