On Tue, 23 Jul 2013 17:29:34 +0100, Colin Hayes
wrote:

.Value = Date + 1

I note this is putting in tomorrow's date, not today's date

but for next Tuesday, change to:

.Value = Date + 8 - Weekday(Date + 5)



OK thanks for these solutions. Both work perfectly first time.

^_^