IF FUNCTION AND DAYS360

Question

Hello,I am trying to have a formula where IF&nbsp; 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)&gt;30 - TRUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; THEN =DAYS360(C1,C2)&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ELSE = "CHECK"then on enter, it just gives me the text&nbsp;=DAYS360(C1,C2)No matter what I do the formula on THEN, automatically puts " " before and after the formulaAny ideas

tauqeeracma · Answer

JULIE2501&nbsp;Try this&nbsp;=IF(DAYS360(C1,C2)&lt;30,DAYS360(C1,C2),"Check")&nbsp;You may also refer to the attached file

sergeibaklan · Answer

JULIE2501&nbsp;
If you want to check actual number of dates between two days, not approximate based on 360 days/year calendar, when better
=IF(C2&lt;=C1+30,C2-C1,"Check")

Forum Discussion

IF FUNCTION AND DAYS360

2 Replies

Resources