DATE Function

How to Do SUMIF by Month and Year in Excel (7 Ways)

If you are looking for some of the easiest ways to do SUMIF by month and year, then you are in the right place. For calculating records of sales or ...

COUNTIFS with Multiple Criteria (5 Easy Methods)

COUNTIF counts cells in a range depending on a single criterion. Whereas COUNTIFS count cells in one or multiple ranges depending on multiple ...

Subtraction Formula in Excel (7 ways)

We all know basic subtraction. It is mainly finding differences between two or more values. This article will show you subtraction formula in Excel ...

How to Add 7 Days to a Date in Excel (3 Methods)

To keep timely records of your work, you need to add dates to your worksheet. If you manually add your date sometimes this process becomes very ...

How to Insert Date in Excel (7 Simple Methods)

There are several purposes for inserting dates in Excel; tracking any information or for any date-time calculation you need to insert dates. Today we ...

How to Add 6 Months to a Date in Excel (2 Easy Ways)

While working in Excel, we often have to work with dates. We have to add or subtract a specific number of days, months, or years from a date for ...

How to Enter Sequential Dates Across Multiple Sheets in Excel

In this regard, When working with dates in Excel, we have learned to enter dates in our various desired orders. Besides, we have learned to enter a ...

How to Add Months to a Date in Excel (2 Ways)

In Excel when you have to adjust the periods of time, you can add months or years to date using some specific functions. This is quite important when ...

How to Autofill Dates in Excel (3 Suitable Methods)

Today I will be showing how to autofill dates in Excel. While working in Excel, many a time we are to work with dates. We are to insert dates in a ...

How to Change Dates Automatically Using Formula in Excel

For easing your task you may demand automatic update of date, time sequence number, etc. Excel provides you with a feature for that. Today we are ...

How to Sort by Date in Excel (9 Suitable Ways)

Today we will be showing how to sort by date in Excel. While working in Excel, we often have to work with dates. From insertion to manipulation and ...

How to Use SEQUENCE Function in Excel (16 Examples)

In Microsoft Excel, the SEQUENCE function is used to generate a sequence of numeric values in different formats. In this article, you'll learn how ...

How to Use SUMIF Function in Excel (5 Easy Examples)

In terms of calculating the summation of some numbers sometimes we may need to apply conditions or criteria. MS Excel helps us with these kinds of ...

How to Use RANDBETWEEN Function in Excel (5 Examples)

Today we will show how you can use the RANDBETWEEN function of Excel to get any random integer between two given numbers. RANDBETWEEN Function ...

How to Use IF Function in Excel (8 Suitable Examples)

In Microsoft Excel, the IF function is used to check if a condition is met and then the defined statements will be shown based on the given ...

ExcelDemy
Logo