Forum Discussion
Help Needed: Calculating Difference Between Two Date Columns in MS Lists
Hi everyone, I'm having trouble calculating the difference between two date columns in Microsoft Lists. Every time I try to use a formula, I get the following error: Sorry, something went wrong. Th...
Hi Dave,
Thanks for your reply. Indeed, the simple calculation works. However, in case the [End date] is still empty, it shows a negative value, which I'd like to avoid.
Hi vchrnk
you can try this calculation:
=IF(OR(ISBLANK([Publish by]), ISBLANK([Draft due by])), "", [Publish by] - [Draft due by])
Best, Dave