IF(NOT(ISNULL( Date_A )), IF(ISNULL( Date_B ), TODAY() – Date_A , Date_B – Date_A ), NULL)

Given the following function definitions:

IF(logical_test, value_if_true, value_if_false)

Checks whether a condition is true, and returns one value if TRUE and another value if FALSE

NOT(logical)

Changes FALSE to TRUE or TRUE to FALSE

ISNULL(expression)

Checks whether an expression is null and returns TRUE or FALSE

TODAY()

Returns the current date

The formula above is a straightforward formula for returning the number of days between two dates, with some conditional checking for null values.


Amit Kumar

Results driven Adobe Certified Architect with extensive experience managing and implementing marketing Strategies to drive business growth. Enjoy optimizing the customer experience through the use of data, futuristic thinking + channel mixing – e.g., using creative combinations of traditional methods + shiny new toys like automation platforms.

Leave a Reply

Your email address will not be published. Required fields are marked *