Originally Posted by
CADastrophe
In that case, the formulas below have been modified from my previous post:
=AND(YEARFRAC(OFFSET(A1,ROW()-1,0),OFFSET(B1,ROW()-1,0))>1-(2/365),YEARFRAC(OFFSET(A1,ROW()-1,0),OFFSET(B1,ROW()-1,0))<1)
(assuming the top row of data or the header is on ROW 1)
...otherwise...
=AND(YEARFRAC(OFFSET(A1,ROW()-1,0),OFFSET(B1,ROW()-ROW(███),0))>1-(2/365),YEARFRAC(OFFSET(A1,ROW()-ROW(███),0),OFFSET(B1,ROW()-1,0))<1)
For each blank, select the cell just above the first line of data for each column.