Forum Discussion
JennyBee
Aug 21, 2024Copper Contributor
Number of days + or -
I am trying to get the difference in the number of days between two dates and it works if the target completion date is before the completion date using this formula: =DATEDIF(H3,J3,"d"). I do get th...
William_Son
Nov 13, 2026Copper Contributor
The #NUM! comes from DATEDIF — it errors when the end date is earlier than the start date. If you just need the signed difference, plain subtraction does it: end minus start (for example =J4-H4) returns a negative number when the end is earlier, with no error. And if you want the plus sign to actually show on positive results, apply the custom number format +0;-0;0 to the cell — positives get a +, negatives keep their minus, and zero shows as 0. (Disclosure: drafted with AI assistance, checked by me.)