Possible nested functions?

[peterderrington]

Hi,

I'm sure what I'm trying to achieve is easy but my brains not in gear today....

I have a spread sheet which contains 2 rows (E and I) that each have a date stamp in them, what I want to do is calculate if the two dates are on the same day and if so return a value.

I firstly tried =DATEDIF(E3,I3,"D") which returns either a 0,1 or #NUM !

What I was wanting was to tidy up that response, to 0 = True, 1 = False and #NUM ! = Blank

I came close when I referenced the cell that the above formula was in like this: =IFERROR(Z3<1,"No")

But I'm guessing that I need to somehow nest the two formulas together.

Can anyone help?

Thanks

 

[peterderrington]

Peter thank you, this works perfectly.

Is it possible to alter the responses from "True" / "False" to something else? No problem if not this works great.

I'll post a new one now to help with my next problem

 

[Peter_SSs]

Peter thank you, this works perfectly.

Good news!

Is it possible to alter the responses from "True" / "False" to something else?

Sure, here is an example

=IF(I3="","",IF(INT(E3)=INT(I3),"Same Day",12345))