Date in Excel

How to Use VBA DATESERIAL Function in Excel (5 Examples)

DATESERIAL function is an Excel time and date function that can be used in VBA to get a date from a specified year, month, and day value. From this ...

How to Use Year Function in Excel VBA (5 Suitable Examples)

The Year function in Excel VBA is under the Date and Time category functions. If we use it in a VBA code, it extracts the year from the date which we ...

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

The MONTH function falls under the Date or Time category. The MONTH function works both in worksheet and VBA Macros. It takes only one argument. In ...

How to Use EoMonth in Excel VBA (5 Examples)

In Microsoft Excel’s Visual Basic for Applications (VBA), there are a lot of built-in functions that can ease the ways of solving complex problems. ...

How to Use the VBA DatePart Function in Excel (7 Examples)

One of the most important and widely used functions that we encounter while working with VBA is the DatePart function of VBA. Today in this article, ...

How to Format Date with VBA in Excel (4 Methods)

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. In this article, we will show you how to ...

How to Use VBA DateValue Function in Excel (6 Examples)

In Excel, various people use different date formats so it is required to have any function to convert any formats into a standard date format. ...

How to Use the Day Function in Excel VBA (3 Examples)

While working in Microsoft Excel Visual Basic for Applications (VBA), we may feel the necessity of using only the day value rather than the entire ...

How to Use the VBA DateAdd Function in Excel

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo