Forum Discussion
SharePoint Calculated Column Blanks & Negative numbers
Hello - I have a calculated column that calculates the amount of days until the due date. My formula is: =DATEDIF(TODAY(),[Contract Expiration Date],"D") How can I revise this formula so I don't ge...
- I figured out the correct formula. Here it is in case anyone else needs it.
=IF(ISBLANK([Contract Expiration Date]),"",IF(ISERROR(DATEDIF(TODAY(),[Contract Expiration Date],"d")),-DATEDIF([Contract Expiration Date],TODAY(),"d"),DATEDIF(TODAY(),[Contract Expiration Date],"d")))
ej24-9 Try using formula like:
=IF(ISBLANK([Due Date]),"",DATEDIF([Another Date Column],[Due Date],"d"))
Make sure to use the correct display names of your date columns in the SharePoint list.
Please consider giving Like if my post helped you in any way.
Thank you! This has helped but I am still getting #NUM! for dates beyond the Due Date i.e. negative results
ej24-9 Try using this:
=IF(ISBLANK([Due Date]),"",IF([Another Date Column]>[Due Date], -1 * DATEDIF([Due Date],[Another Date Column],"d"),DATEDIF([Another Date Column],[Due Date],"d")))Please consider giving a Like if my post helped you in any way.
