If you are using the same date even as the week changes, it would be useful to have a macro that stores the date calculated with +15 in the cell. There is no need to change +15 to +8.