3 ms·Or excel, rc[-1]+366, assuming you typed in the date you want in the cell to the left...by ringshall 7y agoOr excel, rc[-1]+366, assuming you typed in the date you want in the cell to the left...