Counting days between two dates which a day is 7.5 hours

[lacombeg]

Hello,
I am looking for a formula that would count the days between two dates, start and end. My day counts as 7.5 hours, therefore if I put in July 18 as a start date and July 18 as the end date, I would like the result to be 1 day and not 0.
Here is a copy of my spreadsheet.

This is my formula in column B: =WORKDAY(A5,C5)
When inserting amount of days, it automatically inserts the end date

This is my formula in column D: =IF(TODAY()<A5,"",MIN(1,(TODAY()-A5)/C5))

This is my formula in column E: =IF(D5="", "Not started", IF(D5<100%, "In progress", "Completed"))

Column A
Start Date
27-Apr-16
27-Apr-16
2-May-16
9-May-16
11-May-16

Column B
End Date
15-May-16
2-May-16
9-May-16
10-May-16
18-May-16

Column C
Number of Days
14
3
5
1
5

Column D
Percentage Completed
75%
100%
100%
100%
0%

Column E
Status
In progress
Completed
Completed
Completed
In progress

Thanks

 

[lacombeg]

Correct, now it is a formula in C2 that I am looking to get to calculate number of days excluding weekends and holidays.
Thanks

 

[pbornemeier]

With the Planned Start Date in Column A and the Planned Complete Date in Column B, use the NETWORKDAYS formula in Column C to calculate the number of days of work scheduled
Create a list of all holiday dates (other than weekend dates) that should not be counted on as work and name the range that contains those dates 'Holidays'

C2 = =NETWORKDAYS(A2,B2,Holidays) I was wrong earlier, you don't need the +1 in the formula.

 

[lacombeg]

Thank you