How to count date difference in excel?

[joromajr]

-- Question--

I have today's date in A1 and cells B1, D1, F1, and H1 I have encoded
invoice numbers. In Cells C1,E1,G1, and I1 I have encoded dates of invoice.
How do I count the those dates whose difference is from present dates are
over 65 days?


joromajr

 

[daddylonglegs]

I assume your invoice dates are in the past, how are they "encoded"?

If you have actual dates in C1, E1, G1 and I1

=COUNT(C1,E1,G1,I1)-(A1-C1<=65)-(A1-E1<=65)-(A1-G1<=65)-(A1-I1<=65)

 

[joromajr]

--Your the man TY daddylonglegs. It also works the other way round.

joromajr

 

[joromajr]

-- oops--

I spoke to soon.... It worked for invoices... what about for checks?

I tried to replace invoice number with Cheque numbers and dates are in the
future... I get no count?

joromajr

 

[joromajr]

-- I really spoke to soon igot negative return... Please help

joromajr

 

[daddylonglegs]

So if dates are in the future what result do you expect? If you use the
formula I suggested you should get an answer of zero because none of them
will be more than 65 days old.

What formula did you use when you got a negative result, was it exactly what
I suggested?