DATEADD formula - using date plus # days add

This feels really basic, but I don’t know what I am missing and new at the formula editing.

The issue I am having. I am working off one date (Purchase Contract date) and trying to add a number of days (Home Inspection Contingency) to the contract date, to find (Home Inspection Due) due date.

It is working for all number of day options eg: 5 days, 7, 14 etc, except when NONE is selected or when the selection is left blank.

In either of these cases it still populates the date as a purchase contract date. Ideally in Home Inspection Due it would populate NONE.

Is this possible?

My formula is:
DATEADD({Purchase Contract Date}, {Home Inspection Contingency},‘days’)

below. #1 and #2 are wrong, #3 is correct

I don’t think you want {Home Inspection Due} to actually populate with the word “none”, as this would turn the entire field from the “date” type to a “string” (or plain text), meaning you wouldn’t be able to use it in a calendar view or perform additional calculations with it without some extra work.

As an alternative, you can have the field appear blank by adjusting your formula accordingly:

IF(
    AND({Home Inspection Contingency}, {Home Inspection Contingency} != "NONE"), 
    DATEADD({Purchase Contract Date}, {Home Inspection Contingency}, 'days'), 
    BLANK()
)
2 Likes

Thanks so much Kamille, this is perfect and works how I had hoped.

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.