luisitocarrion1900
Board Regular
- Joined
- Oct 30, 2017
- Messages
- 194
- Office Version
- 365
- Platform
- Windows
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))
=IF(ISBLANK(J6),"",IF(ISBLANK(H6),TODAY()-H6,J6-H6))
