Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula Help

Solved
Jump to Solution
120 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone. I’m looking to create a IF statement where if date B exists, then it will calculate the working days between from date A to date B. However if date B does not exists then it will calculate how many days it’s been from date a based on the real time current date. The if statements that I have been trying to create does not work with multiple formulas embedded.

1 Solution

Accepted Solutions

Is this what you want?


IF(

{Date B},

WORKDAY_DIFF( {Date A}, {Date B}),

WORKDAY_DIFF( {Date A}, TODAY())

)

See Solution in Thread

1 Reply 1

Is this what you want?


IF(

{Date B},

WORKDAY_DIFF( {Date A}, {Date B}),

WORKDAY_DIFF( {Date A}, TODAY())

)