Step 6: When we execute the above code we get the following result. Step 5: Display the value stored in our variable using the msgbox function. Step 4: Now let us provide a date to the variable using the date serial function. Step 3: Initiate a subprocedure as follows and declare a variable as date data type. We will work in the same module for all of our examples. Step 2: From the window which is shown above click on the Insert tab to insert a module. Step 1: Before we begin with our examples, first make sure to have developer’s tab enabled and then move to the code section to open the VB Editor by clicking on Visual Basic just like shown in the image below. Let us first provide a simple date to a variable using the date serial function and see the output we get. Let us test this function by a few examples which will make things much clearer for us. You can download this VBA DateSerial Excel Template here – VBA DateSerial Excel Template The function will not return an error instead it will add the two extra months in the current year so the output will be. For example, if I give input as date serial ( 2019, 14, 02), now we know that there can be only 12 months in a year but I have provided 14 as an argument. If we provide the argument above the range accepted, the function does not return an error instead, it calculates the further part of the range and displays the date. The data type for the argument should be an integer.īut here is a cool part of this function.
0 kommentar(er)
