Difference between 2 dates

[jcaptchaos2]

Hello,
I am pulling 2 different dates via VLOOKUP into cells in a spread sheet and then wanting the difference by day returned. The problem in the dates being pulled have time in the also so when I want the different to be zero it returns .29 or something like that.

Code:=IF(AJ28="",AI28-AK28,AJ28-AK28)

 

[Joe4]

Excel stores dates as numbers, specifically the number of days since 1/0/1900, and time is just the fractional component of one day. So to ignore the time portion, just take the integer value of each date, i.e.

[COLOR=#333333]=IF(AJ28="",INT(AI28)-INT(AK28),INT(AJ28)-INT(AK28))[/COLOR]

 

[jcaptchaos2]

Thank Joe

 

[Joe4]

You are welcome.