Thread: Complex date VBA - insert a certain weekday
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Complex date VBA - insert a certain weekday
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)
Reply With QuoteReply With Quote