Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I would like a calculation that gives the number of days between 2 dates (start date & end date) but if end date is blank I would like it to use todays date. How can I set this formula up?
This should do the trick:
=IF(ISBLANK([EndDate]),DATEDIF([StartDate], Today(),"d"),DATEDIF([StartDate], [EndDate],"d"))
Required, but never shown