How to use the VBA DATESERIAL Function (Syntax + Example)

HomeVBA Functions LIST (Category Wise)How to use the VBA DATESERIAL Function (Syntax + Example)

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.

Syntax

DateSerial(Year, Month, Day)

Arguments

  • 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.

Example

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.

Notes

  • 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.

Related Functions

DATE | DATEADD | DATEDIFF | DATEPART | DATEVALUE | DAY | MONTH | MONTHNAME | WEEKDAY | WEEKDAYNAME | YEAR