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"))

 

[cmcordova]

Thank you so much, @Fluff! I repurpsed what you sent for some other columns with the same logic. (Pardon me. I got G2 and H2 mixed up above, but was able to correct my mistake using your formula)

If K36, L36 or M36 are blank then = Sales Initiated
If K36 is before either L36 or M36 then = Marketing Intitiated
otherwise Sales Initiated

From what I see, your formula should work, but as you see below, it's labled row 36 incorrectly, and I can't figure out why.

 

[Fluff]

K36 = M36 so that appears to be working fine.

 

[cmcordova]

But K36 is after L36, so it should be Sales Initiated. If K36 is before either L36 or M36 then it's Marketing Inititiated, but if either of the Sales dates (L36 and M36) are before the marketing date (K36) then it's Sales Initiated.

I really do appreciate all of your help! I'm learning a ton!

 

[Fluff]

Missed that. Check that those dates are real dates & not text.

 

[cmcordova]

They appear to be real dates.

 

[Fluff]

If you change the format of all those cells to General what do you see?

 

[cmcordova]

Oh. I guess they aren't

 

[Fluff]

That's fine, they are real dates.
The formula is saying that if K is less then or equal to either L or M & it is equal to M hence the result.

 

[cmcordova]

Thanks, @Fluff ! I have so much to learn. LOL! I'm still confused. L36 is less than K36, so in my mind it should be Sales Initiated (which is what we want) but I am still not clear as to why it is showing a result of Marketing Initiated.

 

[Fluff]

Because you have an OR K36 <= M36 which returns true, so the fact that K36 > L36 is irrelevant.