
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 01:42 AM
I have a date formula to work out the number of days between 2 dates, if either or both of the dates are blank, it returns NaN, how can I amend the formula to only perform the calculation if both fields are populated?
(Long overdue a lay-in and my brain is not functioning by itself, need help… :slightly_smiling_face: )
DATETIME_DIFF({Finished},{Started},“days”)
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:59 AM
I would use this formula:
IF(
AND(Finished,Started),
DATETIME_DIFF(Finished,Started,"days")
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:18 AM
Hey @Karen_Gardner,
You can use the following condition:
IF(AND(LEN{Finished}!=0,LEN({Started}!=0)),DATETIME_DIFF({Finished},{Started},“days”,0)
The condition checks if both of the given dates are not blank. If the condition is true then it returns your time difference.
Please check it and let us know if it worked :slightly_smiling_face:
Yours sincerely,
Dimitris Goudis

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:27 AM
Getting this error message when copying / pasting the formula.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:31 AM
Sorry I missed some parenthesis :stuck_out_tongue:
Please text me if you have any issue again !

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:42 AM
Still getting the same error message
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:59 AM
Hey @Karen_Gardner,
Could you import the function manually in the filed without using copy and paste?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 02:59 AM
I would use this formula:
IF(
AND(Finished,Started),
DATETIME_DIFF(Finished,Started,"days")
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 03:01 AM
Perfect, thank you. Worked
