CDATE Function

How to Calculate Time Difference in Excel VBA (2 Methods)

While working with times with VBA in Excel, we often have to calculate the time difference between two times. In this article, I’ll show you how you ...

How to Convert Text to Date with Excel VBA (5 Ways)

The date is one of the most prevalent issues we all have with Excel, and it's often kept as text elements and gets overlooked at first. Whenever they ...

VBA Date Function (12 Uses of Macros with Examples)

In Microsoft Visual Basic Application, date functions or any date-related concepts are essential to perform various operations in your dataset. You ...

Excel VBA to Find Week Number (6 Quick Examples)

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

VBA Date to String Conversion in Excel (6 Methods)

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

How to Convert Date from String Using VBA (7 Ways)

If you are looking for some of the easiest ways to convert date from string using VBA, then you are in the right place. By using a VBA code you can ...

ExcelDemy
Logo