=IF(A2=A1,A2+1,A2)
=IF(A2=A1,A2+1,A2)
Maybe:If I put in a date for example 1/1/2015 in A1 and grab the autofill handle and pull down, it adds consecutive dates. I need two identical dates in a row (for keeping track of morning and evening blood pressure readings).
TIA
in A1 type 1/1/15 in A2 type 1/1/15 or any two identical dates and in A3 copy the formula
Code:=IF(A2=A1,A2+1,A2)
and drag the formula down as fr as needed