vendredi 10 août 2018

Excel IF Function Query - Dates

I am looking for some help regarding an IF function on an Excel document.

Basically if the Date Listed cell is dated over 1 month ago (eg: Date Listed 6-Aug but today is 6-Sep) and the Date Sold cell is blank, then I would like the Mark Down cell to say 'MARK DOWN', which at the moment it does but it is only 10-Aug today.

If the Date Listed cell and the Date Sold cell both contain dates I would like the Mark Down cell to say 'OK'.

So far I have this written:

=IF(AND(DATE(YEAR(G2),MONTH(G2),DAY(G2)), ISBLANK(H2)),"MARK DOWN","OK")

I know I'm not far off but I need help sorting out the last parts..

Bonus if you can help me add a highlighted cell formatting to it :)!

EXAMPLE IMAGE

Aucun commentaire:

Enregistrer un commentaire