Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 14, 2022 12:40 PM
I’m trying to use a formula to calculate the number of years between two dates, namely the start and end dates of a job/position – while accounting conditionally for when ether of those fields are blank.
Thought myself rather clever with this formula, but sadly it’s not working.
Can anyone help me figure out what’s wrong?
IF(
{Position Start}=BLANK(),
"",
DATETIME_DIFF(
{Position End},
IF(
{Position End}=BLANK(),
TODAY(),
{Position End}),
'years'
)
)
Mar 14, 2022 12:49 PM
Hey @Shawn_Carrie!
Welcome in!
Try this and let me know if it works:
IF(
{Position Start},
DATETIME_DIFF(
{Position End},
IF(
{Position End},
{Position End},
TODAY()
),
'years'
)
)