I would like to compare every two consecutive cells in a column
and either fill in 0 or a formula, something like this:

if (day(c2) = day(c1),fill in the formula "=r[-1]c + 1", else fill
in zero)--------this sould operate on D1 then copy & paste all the
way to d1225.

Can this be done?