If a calculation equals 0 can i display 1?

[peterderrington]

Hi,
I have a sheet that calculates length of stay, all fairly easy, just subtract column D from Column AE.
The problem i have is that if the answer returns 0 (they arrived and left on the same day) i want it to return 1.
The current formula looks like this and displays nothing at all if either field is blank - i need to retain that feature:
=IF(OR(ISBLANK(D5),ISBLANK(AE5)),"",AE5-D5)

My gut says that a SUMIFS formula could help me here but i'm tying myself up in knots.

Can anyone help?

Thanks

 

[Peter_SSs]

Does this do what you want?

=IF(OR(ISBLANK(D5),ISBLANK(AE5)),"",MAX(AE5-D5,1))

 

[steve the fish]

Surely you want to add 1 to all not just 1?

 

[steve the fish]

I mean if i arrive today and go tomorrow thats two days isnt it?

 

[peterderrington]

Thank you Peter_SSs

That worked perfectly.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[peterderrington]

I mean if i arrive today and go tomorrow thats two days isnt it?

You'd think wouldn't you? But no in this instance if you arrived today and go tomorrow then thats just 1 day.
If you arrive today and leave later today we've still seen you in one day.