Help

Looking for a formula to count days worked on a project.

Topic Labels: Formulas
552 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kelsey123
4 - Data Explorer
4 - Data Explorer

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? 

2 Replies 2
Sho
11 - Venus
11 - Venus

There's DATETIME_DIFF function and WORKDAY_DIFF function available

Formula Field Reference - Overview | Airtable Support

CJSmith
7 - App Architect
7 - App Architect

Hi @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})