Recent Posts

What are Do While Loops and How to Use Them - VBA Tutorial

In VBA, a Do While loop is a type of loop that will continue to repeat a set of instructions until a specific condition is met. Contents:...

VBA Naming Conventions & How to Write Good Variable Names - VBA Tutorial

Naming your variables properly is an important, but often overlooking, building block that, once learned, will improve your codes...

How to Declare Variables and Data Types - VBA Tutorial

Declaring variables is an essential part of programming in VBA. Declaring properly will help you avoid errors and improve the overall...

How to Structure VBA Code and Macros in Excel - VBA Tutorial

When creating macros and writing VBA, it is important to logically structure your code to maximize readability and ensure your code is as...

How to Write Presentable VBA Code and Macros - VBA Tutorial

Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...

What are For Loops and How to Use Them - VBA Tutorial

For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...

How to use the BAHTTEXT Function in Excel with Examples

The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...

How to use the DOLLAR Function in Excel with Examples

The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...

How to Calculate the Number of Days in a Month From a Date

A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...

How to Return the End of the Month From A Date in Excel

Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...

How to Get the First Day of the Month From A Date in Excel

Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...

How to Extract The Year From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

How to Extract The Month From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

How to Extract The Day From any Date in Excel

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

How to Pull Quarters Out of a Date in Excel

When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...