Hi all,
I need to get todays date, and then generate a new date 7 days from todays date.
I can do this in excel and it works
Dim newdate
newdate = DateAdd("d", 7, Date)' adds however many days
newdate = Format(newdate, "ddmmyy") 'formats my date
MsgBox newdate
In this case I will only be...