# Struggling with a formula for counting difference between dates

Topic Labels: Formulas
Solved
801 3
cancel
Showing results for
Did you mean:  4 - Data Explorer

Hello,

I’m trying to make a formula that counts the difference between start date and end date, however if end date is blank calculate the difference between start date, and current date.

Sorry if it sounds simple, i’m very new to airtable!

Thanks
Matt

1 Solution

Accepted Solutions  13 - Mars

Hi @Matthew_Grundy - try this:

``````IF(
{End Date},
DATETIME_DIFF({End Date}, {Start Date}, 'days'),
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)
`````` JB

3 Replies 3  13 - Mars

Hi @Matthew_Grundy - try this:

``````IF(
{End Date},
DATETIME_DIFF({End Date}, {Start Date}, 'days'),
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)
`````` JB  18 - Pluto

Here’s another way to write it, putting the IF function inside a single DATETIME_DIFF:

``DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, "days")``  4 - Data Explorer

Works perfectly! 