How to count date difference in excel?
 

-- 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

How to count date difference in excel?
 

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" wrote:


-- 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

How to count date difference in excel?
 

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

joromajr


"joromajr" wrote:


-- 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

How to count date difference in excel?
 

-- 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" wrote:


-- 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

How to count date difference in excel?
 

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

joromajr


"joromajr" wrote:


-- 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

How to count date difference in excel?
 

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?

"joromajr" wrote:


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

joromajr


"joromajr" wrote:


-- 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