Comparing two dates

[LRiggin]

Hello,

I have a spreadsheet with multiple dates on it. I am essentially looking to compare dates between 2 columns. One column is the most recent visit date and the other column is when we last provided a service. I want to know if there has been more than a year between the most recent visit and the last service date. I did this successfully using conditional formatting ie =A1-B1> 365, applying to all of B column. Now I want to be able to count those cells (macros to count conditional formatting is beyond my skill level).

So far I have: =COUNTIF('Raw Data'!B1:B500,">('Raw Data'!A1:A500)-365)")

I think the problem lies in the minus 365 bit because when I delete that, I get the same answer.

Thank you so much.

 

[jtakw]

Hi,

You can do this (Not sure which column is which, adjust if needed):

Book1
	A	B	C	D
1	12/18/2018	10/15/2018		3
2	12/17/2018	10/15/2017
3	12/16/2018	1/1/2018
4	12/15/2018	1/1/2017
5	12/14/2018	12/31/2017
Sheet406

Cell Formulas
Range	Formula
D1	=SUMPRODUCT(--(B1:B5>A1:A5-365))

 

[LRiggin]

Thank you so much! Worked perfectly

 

[jtakw]

You're welcome, welcome to the forum.