Sum Dates

[luisitocarrion1900]

I have the below but i also need it to count days between Out Date (H6) and Return Date (J6) if J6 is blank on G6 will have the day count using today date until a date is put in J6

=IF(ISBLANK(J6),"",IF(ISBLANK(H6),TODAY()-H6,J6-H6))

 

[Repush]

maybe:
=IF(ISBLANK(J6),TODAY()-H6,IF(ISBLANK(H6),TODAY()-H6,J6-H6)) ?