what do you have in row 2 and row 4? Are the values real dates or are
they strings?

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgdBfMgPv1TKkdldUDQ

In row 2 and row 4 are real dates entered with a formula.



This works!! I greatly appreciate it!
I'm still not sure why the formula didn't recognize the dates I had. I actually set mine up the exact same way you had with adding 14 to the previous. But once I copied your sheet dates into mine, everything was good.

Again, thank you very much!
Cheers
Tom