IF Formula Help Required

[FM1]

Hi All

I have what should be a fairly basic IF formula, but for some reason, I just cant get it to work.

What Im trying to achieve is, if a cell in Column F (Reported date) field has a value higher than 12/1/2008, then it returns a value of "New", otherwise it equals Column T (Status).

My formula - =IF(F11>12/1/2008,"New",T11), which returns "New" regardless of what the reported date is.

I have tried all variables possible of that formula, but it always either returns a value of "New" or the cell value in Column T. The answer doesnt actually change with the reported date.

Can someone please advise me what Im doing wrong.

Thanks.

[rylo]

FarazM

Please read the rules on Cross Posting.

Duplicate post here