DATE Function

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

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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

ExcelDemy
Logo