a little help on my program file using And formula

[Mike Santuile]

Hi,

Please help me out on my Monitoring report. I have attached herewith the file so you can see. For the column Status of Application with a formula of
=IF(AND([@[Expiration Date ]]-$N$1<31,[@[Date Endorsed to Manning]]=""),"For Endorsement","OK "). Basically, all it does is, if the Expiration date of the CRA/Application Issuance date column is below 30 days it will pop a message "For Endorsement" and OK if greater than 30 days, then if there is a value in Date Endorsed to Manning it will prompt as "OK" also. Right now it's not working I don't what are the causes. Hope you can help me out.

[FDibbins]

Well for a start, I can see nothing in N1?

[ajimieta]

Did you mean that if the different between date of CRA/Application issuance and Expired less than 31 days, and there is still no date endorsed to Manning, so the result will be "For Endorsement", otherwise it will be "OK"?

If like that, just simply replace the $N$1 --> [@[CRA/Application Issuance Date ]]

[Mike Santuile]

Thank you it's ok now..

[FDibbins]

What was the problem, what did you fix?