The VBA DATESERIAL function is listed under the date category of VBA functions. When you use it in a VBA code, it returns a valid date as per VBA’s date format by the supplied day, month, and year. In simple words, you can create a date with day, month, and year input. It’s just like the DATE function in the worksheet.
DateSerial(Year, Month, Day)
- Year: An integer to use as the year in the date.
- Month: An integer to use as the month in the date.
- Day: An integer to use as the day in the date.
To practically understand how to use VBA DATESERIAL function, you need to go through the below example where we have written a vba code by using it:
Sub example_DATESERIAL() Range("A1").Value = DateSerial(2019, 5, 15) End Sub
In the above example, we have used the DATESERIAL to create a date with 2019 as a year, 5 months, and 15 as a day and as a result, it has returned 15-May-19.
- Make sure to use four-digit value for the years.
- If you add day number out the maximum number of days in a month, it will return date by adding excess days to the next month.
- If you add month number out the maximum number of months in a year, it will return date by adding excess months to the next year.