Date in Excel Archives

Excel VBA Textbox to Format Date (4 Suitable Examples)

Jul 11, 2023

When working with UserForms in Excel VBA, it is often necessary to format the date values displayed in TextBox controls for a better user experience. ...

Excel VBA Textbox to Format Date (4 Suitable Examples)

Excel Date Picker for Entire Column

Jun 20, 2023 2

Date Picker is one of the interesting tools of Microsoft Excel. It relieves us from the monotonous work of inserting data for each cell manually. ...

Excel VBA to Find Week Number (6 Quick Examples)

Jun 20, 2023

Most of us have learned that a year has 52 weeks. There are at least six different week numbering systems currently in use around the world. Week ...

Excel VBA to Find Week Number (6 Quick Examples)

VBA Date to String Conversion in Excel (6 Methods)

Jun 20, 2023

Generally, Microsoft Excel performs any task much faster than we do it manually. In this article, we will see how to convert VBA date to string in ...

VBA Date to String Conversion in Excel (6 Methods)

Now and Format Functions in Excel VBA (4 Examples)

Sep 18, 2023

Visual Basic for Applications (VBA) is one of the important parts of Microsoft Excel. VBA allows users to create customize functions and applications ...

Now and Format Functions in Excel VBA (4 Examples)

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

Sep 18, 2023

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 VBA DATESERIAL Function in Excel (5 Examples)

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

Feb 11, 2023

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 Year Function in Excel VBA (5 Suitable Examples)

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

Sep 18, 2023

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 VBA MONTH Function in Excel (7 Suitable Examples)

How to Use EoMonth in Excel VBA (5 Examples)

Feb 8, 2023

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 EoMonth in Excel VBA (5 Examples)

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

Sep 18, 2023

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 Use the VBA DatePart Function in Excel (7 Examples)

How to Calculate Due Date with Formula in Excel (7 Ways)

Jun 20, 2023

In Excel, we can easily calculate the due date of a project by using the DATE formula, EDATE Function, YEARFRAC Function, and WORKDAY Function. ...

How to Calculate Due Date with Formula in Excel (7 Ways)

How to Use IF Formula with Dates (6 Easy Examples)

Sep 18, 2023

While working in Microsoft Excel, there are various formulas to make our work easier. IF formula is one of them. It has a wide range of applications ...

How to Use IF Formula with Dates (6 Easy Examples)

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

Feb 27, 2023

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 Format Date with VBA in Excel (4 Methods)

How to Insert Current Date in Excel (4 Suitable Examples)

Jul 20, 2023

When making an assignment, report or any other business-related document then it’s pretty common to add the current date. Sometimes we need to insert ...

How to Insert Current Date in Excel (4 Suitable Examples)

Date Variable in VBA Codes (7 Uses of Macros with Examples)

Feb 9, 2023

In Microsoft Excel's VBA, there are a lot of essential methods and functions. To use those, we have to declare variables. The Date variable is one of ...