Forum Discussion
JULIE2501
Jul 09, 2019Copper Contributor
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 ...
tauqeeracma
Jul 09, 2019Iron Contributor
Try this
=IF(DAYS360(C1,C2)<30,DAYS360(C1,C2),"Check")
You may also refer to the attached file