Select Page

## How to convert D/M/YYYY date to M/D/YYYY or vice versa

Data formats differ by locations in the world. Once you understand the syntax of dates you can easily convert them from one locale to the other. In this article, we will cover the most standard date conversion in Excel: converting D/M/YYYY to M/D/YYYY. Syntax first...

## How to convert a number to time units

If you want to convert a number to time values, you need some additional operations, multiplying and dividing between days, hours, minutes, and seconds. Here, we’re going to take a look at a simpler approach by using Excel’s TEXT function.   Syntax...

## How to create a calendar that only contain workdays

Be it for creating a time card or planning, creating a flexible calendar where you can omit holidays will come in very handy. Using the WORKDAY function you can easily create such a table and incorporate it in your data models. Syntax =WORKDAY(previous date, 1) Steps...

## How to use day information from date data in Excel

Working with dates in Excel can be a bit challenging at times, because Excel doesn’t use dates as we conceive it. Knowing how Excel handles dates, you will find it pretty easy to use them in calculations and reports. Syntax =date + days Steps Select or type in...

## How to COUNT values between two dates

A quick and easy way to count between dates is by using the COUNTIFS formula. Create formula-based filters, find your sales figures, or organize your tables in no time. Syntax =COUNTIFS(date range, >=minimum date, date range, <=minimum range) Steps Type...

## How to SUM values if date is less than

How much did you spend until last year, or what is the total of X until Y? SUMIF and SUMIFS functions can help you to sum values in your data tables. Syntax =SUMIFS(values to sum range, date range, <maximum date) =SUMIF(date range, <maximum date, values to sum...

## How to SUM values between two dates using SUMIFS formula

Be it for budgeting, reporting, or analysis, you can easily sum data within a date range using the SUMIFS formula. SUMIFS is an extended form of SUMIF formula where you can enter multiple criteria. Syntax =SUMIFS(values to sum range, date range, >=minimum date,...