Yes, the range should always be the same. Now I just need to fix the following minor problems:
1. The cells that have a strikethrough date(s) followed by a red date, the red dates are being deleted but they are not supposed to be. The red date need to be kept (and changed to black if possible).
2. Is there a way to shift the values up (by delete the empty lines above) to the first line in the cell after deleting the dates before?
3. Some strikethrough dates are kept after running the macro.

Thanks