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]

Would it be possible to make it relevant? if there is a value in K2 and either L2 or M2 are before K2, it should result in Sales Initiated

I tried this, and no dice: =IF((OR(AND(K2<>"",K2<=L2),AND(K2<>"",K2<=M2),"Marketing Initiated","Sales Initiated"))

 

[Fluff]

Can you please decide exactly what the criteria, rather than constantly moving the goal posts.

 

[cmcordova]

Yes! I've asked the same thing of Marketing. LOL!

In a nut shell,

If there is a value in Original Marketing Qualified Date (K) and it is before or equal to EITHER Original Sales Accepted Date (L) or Recent Sales Accepted Date (M) then it is Marketing Initiated, otherwise its Sales Initiated

The below scenario in green should result in Sales Initiated because even though Original Marketing Qualified Date (K) and Recent Sales Accepted Date (M) are the same, Original Sales Accepted Date (L) is before Original Marketing Qualified Date (K) The other values in column N are correct.

Thank you so much!

 

[Fluff]

You are contradicting your self with

If there is a value in Original Marketing Qualified Date (K) and it is before or equal to EITHER Original Sales Accepted Date (L) or Recent Sales Accepted Date (M) then it is Marketing Initiated,

and

The below scenario in green should result in Sales Initiated because even though Original Marketing Qualified Date (K) and Recent Sales Accepted Date (M) are the same, Original Sales Accepted Date (L) is before Original Marketing Qualified Date (K)

 

[cmcordova]

Thank you so much for your help @Fluff! I really appreciate the time you have spent, and I have learned a lot!

I'm struggling to think of another way to explain the criteria. I'll keep playing with it and hopefully figure it out. I have a ton to learn.

Thanks again!