Question: how to set date in excel vba?
Answer: To declare a date, use the Dim statement. To initialize a date, use the DateValue function. Note: Use Month and Day to get the month and day of a date.