I need to compare a date in a list column with today's date and show the difference, this works using this formula:
=DATEDIF(Today,[Vendor Warranty Expiry],"D")
using the Today column trick, but it returns #NUM! when the date has passed.
I need to show the days as -5 (for a date that has passed by 5 days), I have tried various formulas I have found on the web but all error with syntax issues.
Can anyone help please?
Also, can I use some other formula to dynamically get today's date other than the Today column trick/fudge.
View Complete Post