 • 512K Members
• 7,540 Online
• 609K Conversations

# 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

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

2 Replies

# Re: IF FUNCTION AND DAYS360

Try this

=IF(DAYS360(C1,C2)<30,DAYS360(C1,C2),"Check")

You may also refer to the attached file

# Re: IF FUNCTION AND DAYS360

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")`
Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
Which formula to use
Ramon Haagen in Excel on
2 Replies
Excel If Functions