Home

IF FUNCTION AND DAYS360

%3CLINGO-SUB%20id%3D%22lingo-sub-744910%22%20slang%3D%22en-US%22%3EIF%20FUNCTION%20AND%20DAYS360%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744910%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20have%20a%20formula%20where%20IF%26nbsp%3B%20the%20number%20of%20days%20between%20two%20dates%20is%20more%20than%20lets%20say%2030%2C%20I%20should%20get%20a%20message%20e.g.%20%22check%22%3C%2FP%3E%3CP%3EI%20input%20formula%20%3DIF(%3DDAYS360(C1%2CC2)%26gt%3B30%20-%20TRUE%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20THEN%20%3DDAYS360(C1%2CC2)%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20ELSE%20%3D%20%22CHECK%22%3C%2FP%3E%3CP%3Ethen%20on%20enter%2C%20it%20just%20gives%20me%20the%20text%26nbsp%3B%3DDAYS360(C1%2CC2)%3C%2FP%3E%3CP%3ENo%20matter%20what%20I%20do%20the%20formula%20on%20THEN%2C%20automatically%20puts%20%3CSTRONG%3E%22%20%22%20before%20and%20after%20the%20formula%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EAny%20ideas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744910%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744938%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20AND%20DAYS360%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373390%22%20target%3D%22_blank%22%3E%40JULIE2501%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(DAYS360(C1%2CC2)%26lt%3B30%2CDAYS360(C1%2CC2)%2C%22Check%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20also%20refer%20to%20the%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744958%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20AND%20DAYS360%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373390%22%20target%3D%22_blank%22%3E%40JULIE2501%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20check%20actual%20number%20of%20dates%20between%20two%20days%2C%20not%20approximate%20based%20on%20360%20days%2Fyear%20calendar%2C%20when%20better%3C%2FP%3E%0A%3CPRE%3E%3DIF(C2%26lt%3B%3DC1%2B30%2CC2-C1%2C%22Check%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
JULIE2501
Occasional Visitor

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

@JULIE2501 

Try this 

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

 

You may also refer to the attached file

@JULIE2501 

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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies