Formula question

[Jillybean9621]

HI all,

I could use some help. I really tried to figure this out on my own but can't quite get there.

I have two columns I am trying to compare but they have different data.

I2 J2 K2
Days submittal date
84 Formu 7/14/16



what I am working to do is shows an if statement. If column I2 is greater than 7 then it will show "late submittal", otherwise it will show "pending submittal"
=IF(I2>7,"LATE SUBMITTAL","PENDING SUBMITTAL")

here is where I need to add something in for Column K2.
if K2 is showing a date that is I want JT2 to be blank. is that possible?

Days from Design Late/Pending 1ST PERMIT SUBMITTED
84 LATE SUBMITTAL 7/14/2016

 

[SammyKoo]

what other data will there be in your K2 other than dates?
and what if it is not showing a date, what would it shows?
i would suggest to use the if function thou, =if(K2<1,"something","")
not sure if this helps

 

[Jillybean9621]

what other data will there be in your K2 other than dates?
and what if it is not showing a date, what would it shows?
i would suggest to use the if function thou, =if(K2<1,"something","")
not sure if this helps

TRYING TO DO SOMETHING LIKE THIS

=IF(I2="",IF(M2>J2+7,"LATE SUBMITTAL","ON TIME SUBMITTAL"), (M2>I2+7,”LATE SUBMITTAL”,”ON TIME SUBMITTAL”))

BUT I GET AN ERROR.

Coax Design Complete Fiber Design Complete Days from Design 1ST PERMIT SUBMITTED LATE/ON TIME
08/30/2017 no data 84 7/14/2016 ON TIME SUBMITTAL