VBA Migration

Excel dates are based on the number of days since 1 January 1900.
Dates are based on a time value that is the number of milliseconds since 1 January 1970 UTC.

VBA.DateAdd

DATEADD - Returns the date with a specified time interval added.

VBA.DateDiff

DATEDIFF - Returns the number of a given time interval between two specified dates.

VBA.DatePart

DATEPART - Returns the specified part of a given date.

VBA.DateValue

DATEVALUE - Returns the date given a string representation of a date.