Question: how to calculate date in excel vba?
Answer: VBA DateAdd Function You can use the DateAdd Function to add a date/time interval to a date or time, and the function will return the resulting date/time. The syntax of the DateAdd Function is: DateAdd(Interval, Number, Date) where: Interval – A string that specifies the type of interval to use.