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

[Kelsey123]

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? 

[Sho]

There's DATETIME_DIFF function and WORKDAY_DIFF function available

Formula Field Reference - Overview | Airtable Support

[CJSmith]

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