Recent Posts

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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