I thought this would be difficult. In turn it was easy. A simply =SUM(A1+7) where A1 is a previous date works. It even understands leap years like 2012. Saved me loads of time.
I’m a small business consultant enabling small business owners to achieve sustainable growth, whilst working part-time at Tees Valley Arts. For more about me personally see peterneal.co.uk