I have a form that a user is filling out by using SharePoint Columns. There are a varied amount of dates that they get to choose from. The form will take a start date and an end date and count the total number of days between them.
For example Start Date:
4/2/18 End Date: 4/9/18 is a total of 8 days.
If I use the following code in SP 2016:
=DATEDIF([Start Date],[End Date]+1,"D")
The formula will work. However, it adds 1 whenever there are no dates entered. I need to account for all the zeros/blanks and create a report out of that. So I need to see the blanks/zeros.
What formula can I use that just counts the days without having to add 1 to include the date?
I've tried: =DAYS(End Date,Start Date) and this returns #NUM. Can anyone help?