How to delete text in Excel and using calculation data?

[hanbell77]

Hi All,

Urgently need ur help on how to delete the text in weekend column. I want to set running every monday but change the date base on weekend. Example i running on 17th Feb i want to key in the weekend on 22th Feb. same goes to next week. Running on 24th Feb and key in the weekend on 3rd Mar