Calculate Between two dates

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
51
I need a formula that will calculate two dates

Sample

In Column K put the number of dates between the Starting Date (I20) and Ending Date (J20), but if I20 or J20 is blank Leave K blank
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,378
Office Version
365
Platform
Windows
How about
=IF(OR(I20="",J20=""),"",J20-I20)
 

Forum statistics

Threads
1,078,134
Messages
5,338,430
Members
399,232
Latest member
stevenmoritz

Some videos you may like

This Week's Hot Topics

Top