Just for clarification, once the year span is met, then the 365 days starts again from the last date. I hope that makes sence because its difficult for me to out in words even thoguh I know what I am trying to convey. Either way, I used your formula and it was perfect...I scrolled through the lines to fix those occassional hiccups but other than that your formula worked and I appreciate your assistance.