Dates

P

phil

Hi

I Am trying to work out the difference between 2 dates, if the dates are
under say 30 day i need it to count it.

so if i have
23/04/2007 & 2404/2007
and
22/01/2007 & 24/04/2007

It will only count the cells that have a date less than 30days?
Any suggestion

Thanks for your help
 
T

T. Valko

Try this:

I'm assuming the dates are in 2 columns:

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(ISNUMBER(B1:B10)),--(ABS(A1:A10-B1:B10)<30))

Biff
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A20<>""),--(B2:B20<>""),--((A2:A20-B2:B20)<30))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top