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: )
Solved! Go to Solution.
You can use the following condition:
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: