Between dates formula

[DeCaelo]

A1 = 18/04/11 06:00
B1 = 07:00
C1 = 18/04/11 06:30

I'm struggling to find a formula that works out if C1 is between A1 + B1 as there is no date attached to B1. Any ideas?

 

[Weaver]

=IF(AND(C1> A1,C1< A1+B1),"Yes","No")

So long as there's never a date attached to B1

 

[DeCaelo]

=IF(AND(C1> A1,C1< A1+B1),"Yes","No")

So long as there's never a date attached to B1

The only problem with that formula is A1+B1 would equal 18/04/11 13:00, so wouldn't accurately show anomalies.

 

[shift-del]

Hi

What about this?

=MEDIAN(TRUNC(A1,0)+B1,A1,C1)=TRUNC(A1,0)+B1

 

[ukmikeb]

Or -

=IF(AND(C1>=A1,C1<=INT(A1)+B1),"yes","no")

hth

 

[DeCaelo]

Hi

What about this?

=MEDIAN(TRUNC(A1,0)+B1,A1,C1)=TRUNC(A1,0)+B1

That shows "FALSE"

 

[DeCaelo]

If I were to copy A1 to D1 and format it as dd:mm:yyyy, so it only show 18/04/11, is there a formula to use that date rather than the number?

 

[shift-del]

That shows "FALSE"

My mistake.

=MEDIAN(TRUNC(A1,0)+B1,A1,C1)=C1

 

[DeCaelo]

My mistake.

=MEDIAN(TRUNC(A1,0)+B1,A1,C1)=C1

Works perfectly :D

Thankyou so much.