IF FUNCTION AND DAYS360

[JULIE2501]

Hello,

I am trying to have a formula where IF  the number of days between two dates is more than lets say 30, I should get a message e.g. "check"

I input formula =IF(=DAYS360(C1,C2)>30 - TRUE

                        THEN =DAYS360(C1,C2)    

                        ELSE = "CHECK"

then on enter, it just gives me the text =DAYS360(C1,C2)

No matter what I do the formula on THEN, automatically puts " " before and after the formula

Any ideas

[#2]

@JULIE2501 

Try this 

=IF(DAYS360(C1,C2)<30,DAYS360(C1,C2),"Check")

You may also refer to the attached file

[#3]

@JULIE2501 

If you want to check actual number of dates between two days, not approximate based on 360 days/year calendar, when better

=IF(C2<=C1+30,C2-C1,"Check")