Recent Posts

How to Calculate Working Days Passed in Current Month

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) that have passed in...

Tutorial

GitHub Style Habit Tracker & Calendar Heat Map in Excel

I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version...

Tutorial

How to Calculate Working Days in a Month

When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) in a month, from a...

Tutorial

How to Calculate Number of Days Between Two Dates in Excel

A short formula you can use to calculate the number of days between two specific dates. Contents: 1. Formula 2. Explanation 3. Example...

Tutorial

How to Calculate Weekend Days Between Two Dates in Excel

An easy formula you can use to calculate the number of weekend days between two specific dates. Contents: 1. Formulas 2. Explanation 3....

Tutorial

How to Calculate Number of Weekend Days Left in the Current Month in Excel

A quick formula to calculate the number of weekend or non-working days remaining in the current month. Contents: 1. Formulas 2....

Tutorial

How to Calculate Number of Weekdays Left in the Current Month in Excel

A quick formula to calculate the number of weekdays, business days, or working days remaining in the current month. Contents: 1. Formulas...

Tutorial

How to Highlight Weekdays in Excel

Using conditional formatting, we can use a custom formula to highlight all weekday dates from any date range, letting you visually see...

Tutorial

How to Highlight Weekends in Excel

Using conditional formatting, we can use a custom formula to highlight all weekend dates from any date range, letting you visually see...

Tutorial

How to Convert a Month Name to a Number in Excel

Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...

Tutorial

How to Round a Date to the First of the Next Month

Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...

Tutorial

How to Round a Date to the First of the Previous Month

Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...

Tutorial

How to Remove Date Data from a Time in Excel

Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...

Tutorial

How to Remove Time from a Date in Excel

Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...

Tutorial

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

Tutorial

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

Tutorial

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

Tutorial

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

Tutorial

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

Tutorial

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