I am running a SharePoint formula that calculates the length of time (in yrs, months, and days) before a project expires.
In the "Will Expire" column the following formula is running:
=DATEDIF(CurrentDate,[End Date],"Y")&" Years "&DATEDIF(CurrentDate,[End Date],"YM")&" Months "&DATEDIF(CurrentDate,[End Date],"MD")&" Days"
The "CurrentDate" column is updated daily as part of a Power Automate job. The "End Date" column is manually added as part of the project term.
For expired projects, a result is a negative number which is an error with DATEIF that shows up as #NUM!.
I do not want negative numbers to show and used DATEDIF to get an error in hopes of changing the error to something more user friendly.
However when adding an ISERROR statement - I cannot get the syntax of the combined statements to work.
Any help or ideas to use a better way appreciated.