• 541K Members
• 6,216 Online
• 644K Conversations

## IF FUNCTION AND DAYS360

Highlighted
Occasional Visitor

# 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
Highlighted

# Re: IF FUNCTION AND DAYS360

Try this

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

You may also refer to the attached file

Highlighted

# 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
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Excel If Functions