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...
top of page
Recent Posts
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...
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...
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...
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....
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
bottom of page