Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

5 - Automation Enthusiast
since ‎Dec 21, 2022
‎Feb 08, 2024

## User Statistics

• 9 Posts
• 0 Solutions
• 4 Kudos given
• 1 Kudos received

## Count Number of Weekdays

Is there a way to count the number of weekdays between a date range? I am currently using the following formula to count the number of days between the FROM and TO DATE:DATETIME_DIFF({To Date}, {From Date}, 'days')+1 If the date range includes a week...

## Update Linked Field After Form is Submitted on Another Table

This is basically a leave tracker. Table 1: Employee DetailsThis table contains the start date of the employee and a column that computes the available leave credits they have accumulated.Column LEAVES is linked to Table 2 and should look up the dura...

## Multiple IF AND statements

I'm trying to compare data from 2 columns to result in a rating. I'm trying to break it down first before going crazy with multiple IF AND statements. Below is the first working example:IF(AND(A=100, B=100), 5, BLANK())Below are the conditionsIF A=10...
Kudos from
Kudos given to