Jul 09 2019 07:04 AM
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
Jul 09 2019 07:13 AM
Try this
=IF(DAYS360(C1,C2)<30,DAYS360(C1,C2),"Check")
You may also refer to the attached file
Jul 09 2019 07:23 AM
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")