Forum Discussion
Solved
2 IF Conditions with DATEDIF forumula, returns number even if conditions aren't met
I am receiving chapters from authors, sending them to editors, and getting them back from editors. Need to count the # of days a chapter has been with an editor, but not if the chapter has been r...
Hi Leah,
Please try this formula:
=IF(AND(ISNUMBER(C2),ISNUMBER(B2),ISNUMBER(A2)),"complete",
IF(AND(ISNUMBER(A2),B2="",C2=""),"not to editor",
IF(AND(A2="",B2="",C2=""),"not in",
IF(AND(ISNUMBER(A2),ISNUMBER(B2)),DATEDIF(B2,TODAY(),"d"),""))))And find it in the attached file.
Regards
Hi Leah,
Please try this formula:
=IF(AND(ISNUMBER(C2),ISNUMBER(B2),ISNUMBER(A2)),"complete",
IF(AND(ISNUMBER(A2),B2="",C2=""),"not to editor",
IF(AND(A2="",B2="",C2=""),"not in",
IF(AND(ISNUMBER(A2),ISNUMBER(B2)),DATEDIF(B2,TODAY(),"d"),""))))
And find it in the attached file.
Regards
Thank you Haytham!
Your solution works exactly like I hoped.