Date Manipulation of Components

Question

Is it possible to manipulate the components, such as year, month, daya datein VBA? I need a function that, given the day, month, and year, returns the corresponding date.

Answer 1

DateSerial(YEAR, MONTH, DAY)

will be what you are looking for.

DateSerial(2008, 8, 19) returns 8/19/2008

Answer 2

There are several date functions in VBA - check this site

DateSerial (YEAR, MONTH, DAY)

Answer 3

Do you want DateSerial :

Dim someDate As Date = DateSerial(year, month, day)