If-Then statement not properly displaying duration (G18) of two dates (E18 & F18)

[anujual]

E18 - Start Date (5/7/18)
F18 - End Date (5/10/19)
G18 - Duration in days (# days)

G18 has the following formula:
=IF(AND(DATEDIF(E19,F19,"yd")=0),"1",DATEDIF(E19,F19,"yd"))&IF(DATEDIF(E19,F19,"yd")=1," day"," days")

I dragged G18 down to apply the formula to the rows below it (ie. G19, G20, G21, etc.), however E19/F19, E20/F20, E21/F21, etc. don't have any dates in them yet, so I want to keep G19, G20, G21, etc. blank.

Currently, G19, G20, G21, etc. have "1 day" in them, which I don't want. It should be blank, but with the formula running for when dates are entered in E and F. Any suggestions? Thanks!

[JohnTopley]

Try

=IF(OR(E18="",F18=""),"",IF(AND(DATEDIF(E19,F19,"yd")=0),"1",DATEDIF(E19,F19,"yd"))&IF(DATEDIF(E19,F19,"yd")=1," day"," days"))

[anujual]

Thank you JohnTopley! I tried it out, and it worked to make G19/G20/G21,etc. blank.

[anujual]

One last edit, this was weird when I tried to play around with the formula. I tried two of the following inputs for dates.

5/7/18 to 5/7/18...resulted in...'1 days' ---> using days for one is awkward. Is there a way to make these two both '1 day'?

5/7/18 to 5/8/18...resulted in...'1 day'

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

[anujual]

Thank you AliGW - it's updated!

[JohnTopley]

Try

=IF(OR(E19="",F19=""),"",IF(DATEDIF(E19,F19,"yd")<=1,"1 day",DATEDIF(E19,F19,"yd")&" days"))