SUM formula not populating correcly

[Lost_Our_Home_P]

We have two columns that we need added to a third sum column. Our first column is our Admit Date for people using our program and the second is Exit Date for when they leave the program. We need our Admit Date and Exit Date columns to populate to a total days in care. Right now we have the formula as: SUM({Exit Date}-{Admit Date}) but it is giving us a message of NaN when an admit and exit date are plugged in.

[Zollie · Accepted solution]

NaN stands for ‘not a number.’ SUM only operates on numbers - it won’t work with a date. You might say it has no concept of time :winking_face: The date functions are listed here.

Haven’t tested it yet, but I think your formula will be:

DATETIME_DIFF({Admit Date}, {Exit Date}, 'days')

[Lost_Our_Home_P]

Thank you! It was exit date first, but otherwise perfect!