Date comparison IF statement

[#1]

Hi there,

I have a table like the below. I'd like to say

IF [Due Date] is before TODAYS DATE then, colour the cell RED

I have the below so far:

IF([Target Date] ={'>$(=date(today(),'dd/mm/yyyy''))'} and [Action Status]='Open',LightGreen(),  yellow())

Can you help me get this right?

[tresesco · Accepted solution]

May be this?

IF([Target Date] =date(today(),'dd/MM/yyyy') and [Action Status]='Open',LightGreen(),  yellow())

Or, even

IF([Target Date] =today() and [Action Status]='Open',LightGreen(),  yellow())

[Chanty4u]

mm takes as minitues so u can use 'MM'