Complex date VBA - insert a certain weekday
In article , Ron Rosenfeld
writes
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.
^_^
|