SUM formula not populating correcly

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.

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 :wink: 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')
1 Like

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

2 Likes

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