Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

DATE Function

How to Do SUMIF by Month and Year in Excel (7 Quick 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 ...

How to Use COUNTIFS Function with Multiple Criteria in Excel

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

How to Create a Formula in Excel (5 Easy Ways)

Excel can be used to perform any type of calculation and creating a formula is the basis of the calculation. In this article, you will learn how to ...

How Do I Add 7 Days to a Date in Excel (5 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 Suitable Methods)

Inserting dates in Excel can be used for a variety of purposes, including data tracking and date-time calculations. In this article, we are going to ...

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)

While working in Excel, many a time we are to work with dates. We are to insert dates in a single cell or a range of cells. Today I will be showing ...

How to Perform Automatic Date Change in Excel Using Formula

Today we are going to show some automatic date change formula in Excel, in other words,  how to change dates automatically through formulas in ...

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 Lookup with Multiple Criteria in Excel (2 Easy Ways)

While working in Excel, we are to do this often. We are to look up a particular value in a data set that satisfies one or more criteria. Today I will ...

How to Use SUMIF Function in Excel (7 Suitable 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 Ideal 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 ...

ExcelDemy
Logo