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
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
You may also refer to the attached file
If you want to check actual number of dates between two days, not approximate based on 360 days/year calendar, when better