Calculate Between two dates

luisitocarrion1900

Board Regular
Joined
Oct 30, 2017
Messages
120
Office Version
365
Platform
Windows
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,089,999
Messages
5,411,748
Members
403,394
Latest member
Mohan Kumar

This Week's Hot Topics

Top