Forum Discussion
IF FUNCTION AND DAYS360
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 ...
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")