days calculation with multiple if statements

[dmccarley1979]

DATA IS

A B C D E
1 start date start time end date late start DAYS USED
2 10/7/17 11:47 10/18/17 NO
3 10/9/17 13:34 10/25/17 YES
4 10/9/17 17:04 10/28/17 YES
5 10/10/17 9:52 10/28/17 NO
6 10/19/17 9:21 10/30/17 NO
7 10/14/17 9:50 10/28/17 NO
8 10/20/17 12:05 YES
9 10/20/17 12:00 YES

Column D Formula reads =IF(B2 < TIME(12,0,0),"NO",IF(B2 > =TIME(12,0,0),"YES","0"))

Column E currently reads =IF(D2="NO",DAYS(C2,A2)+1, DAYS(C2,A2))

C8 and C9 do not have a date because the end time has not been reached.

I need some help with a change to formula in E that specifies if the C cell is empty then treat it as if it was today and still follow the current formula written in E that looks to D for "NO".

Thanks in advance

[daddylonglegs]

Try this formula for E2 copied down

=IF(D2="NO",1,0)+DAYS(IF(C2="",TODAY(),C2),A2)

[dmccarley1979]

Try this formula for E2 copied down

=IF(D2="NO",1,0)+DAYS(IF(C2="",TODAY(),C2),A2)

perfect. Thank you!