DATE Function Archives

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

Oct 3, 2021 Excel Basics

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)

Oct 10, 2021 Excel Basics

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 Months to a Date in Excel (2 Ways)

Oct 3, 2021 Excel Basics

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 Change Dates Automatically Using Formula in Excel

Oct 12, 2021 Excel Formulas

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 (8 Suitable Ways)

Oct 27, 2021 Excel Formulas

Today I will be showing how to sort a data set in Excel by date. While working in Excel, we often have to work with dates. From insertion to ...

How to Use SEQUENCE Function in Excel (16 Examples)

Sep 22, 2021 Excel Functions

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 (Both AND or OR Type)

Oct 27, 2021 Excel Formulas

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 (With 5 Easy Examples)

Sep 21, 2021 Excel Formulas

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 (4 Examples)

Oct 10, 2021 Excel Formulas

Today I will be showing how you can use the RANDBETWEEN function of Excel to get any random integer between two given numbers. RANDBETWEEN ...

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

Sep 21, 2021 Excel Functions

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

How to Use WORKDAY Function in Excel (5 Examples)

Sep 21, 2021 Excel Functions

There are a number of functions in Excel to make operations simpler, easier and speedy. Today we are going to show you how to use the WORKDAY ...

How to Use WEEKDAY Function in Excel ( With 8 Examples)

Sep 21, 2021 Excel Formulas

The WEEKDAY function is especially handy for planning, scheduling, and even financial analysis. It is classified as a Date and Time function in Excel ...

How to Use DATE Function in Excel (8 Examples)

Oct 10, 2021 Excel Formulas

Today I will be showing how you can use Excel's DATE function with Formulas. Download Practice Workbook Excel DATE Function with Formulas ...

How to Use DAY Function in Excel (With 3 Examples)

Sep 21, 2021 Excel Functions

Excel provides several functions to maximize and speed up your productivity. Today we are going to show you the usage of the DAY function. For ...

Excel If Statement with Multiple Conditions in Range (3 Suitable Cases)

Oct 27, 2021 Excel Formulas

Today I will be showing how you can use the IF statement with multiple conditions in any range in Excel. Download Practice Workbook Excel ...