Comparing date cells and blanks

[cmcordova]

Hello all!

I am trying to compare values in G2 and H2 based on the below criteria:

• Both are date fields
• If G2>H2 then "Sales Initiated"
• If G2<H2 then "Marketing Initiated"
• If G2=H2 then "Marketing Initiated"
• If G2 is blank, but H2 is not, then "Sales Initiated"
• If G2 is not blank, but H2 is blank, then "Marketing Initiated"
• If both G2 and H2 are blank, then ""

I started with the below formula, but it doesn't take into consideration if one cell is blank and not the other or if they are the same. Any help is greatly appreciated!
=IF(AND(ISBLANK(G2), ISBLANK(H2)),"",IF(G2>H2), "Sales_Initiated", "Marketing_Initiated"))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(AND(G2="",H2=""),"",IF(AND(H2<>"",OR(G2="",G2>H2)),"Sales Initiated","Marketing Initiated"))

 

[cmcordova]

Hi & welcome to MrExcel.
How about

=IF(AND(G2="",H2=""),"",IF(AND(H2<>"",OR(G2="",G2>H2)),"Sales Initiated","Marketing Initiated"))

This is great, but doesn't seem to take into account when both cells are blank, which should result in "Marketing Initiated." How would I add that bit? Thanks so much for your help and super quick response, @Fluff !

 

[Fluff]

but doesn't seem to take into account when both cells are blank, which should result in "Marketing Initiated."

But you said

If both G2 and H2 are blank, then ""

 

[cmcordova]

But you said

Ugh. My bad! I clearly need a third cup of coffee today. Thanks so much for your help!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[cmcordova]

Hello @Fluff.

I could really use your help again as the criteria has evolved today. Another date column, I2 has been added.

If G2, H2 and I2 are null then "Sales Initiated"
If G2 > H2 or I2 then "Sales Initiated"
If either H2 or I2 > G2 then "Marketing Intitiated"
In a nut shell, if the date in H2 is before either of the other fields it's "Marketing Initiated" and all other scenarios will be Sales Initiated

I tried to build upon what you gave me yesterday, but I'm missing something:
=IF(AND(G2="",H2="",I2=""),"Sales Initiated",IF(AND(G2<>"",OR(G2="",G2>H2),"Sales Initiated",IF(AND(G2<>"", OR(G2="",G2>I2),"Sales Initiated","Marketing Initiated")

I would be so grateful for your help once again!

 

[Fluff]

How about

=IF(AND(H2<>"",OR(H2<G2,H2<I2)),"Marketing Initiated","Sales Initiated")

 

[cmcordova]

This is amazing!! I forgot one thing. How would I add if H2=G2 or I2 (and neither are before G2) then = Marketing Intitiated?

I so appreciate your help!!

 

[Fluff]

Maybe

=IF(AND(H2<>"",OR(H2<=G2,H2<=I2)),"Marketing Initiated","Sales Initiated")