CDATE Function Archives

CDATE Function

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

Mar 13, 2023 Macros & Excel VBA

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)

Feb 13, 2023 Macros & Excel VBA

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)

Feb 9, 2023 Macros & Excel VBA

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)

Feb 14, 2023 Macros & Excel VBA

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)

Feb 28, 2023 Macros & Excel VBA

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)

Feb 27, 2023 Macros & Excel VBA

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