DATE function Archives

4 Easy Ways to Calculate Percentage of Time in Excel

March 27, 2023

Every once in a while we may need to know how much time is spent on our different everyday tasks so that we can make a schedule. It helps us to plan ...

3 Ways to Calculate Accrued Interest on Fixed Deposit in Excel

March 21, 2023

In our everyday life calculating the accrued interest amount from the fixed deposit is a very common task. People nowadays prefer to make savings ...

7 Easy Ways to Create Due Date with Formula in Excel

January 4, 2023

Sometimes we face a deadline within which we want to finish some work. In a company providing deliveries within a fixed time is very important. ...

7 Easy Ways to Use SUMIF by Month and Year in Excel

February 16, 2023

There may be times when you need to know easily how to use SUMIF by Month and Year in Excel. For example, you may need to use an Excel formula or VBA ...

7 Tricks to Apply SUMIFS in Date Range with Multiple Criteria

April 9, 2023

Sometimes you need to add up numbers in Excel that fall within a date range. To achieve this, we often apply SUMIFS date range multiple criteria A ...

5 Ways to Convert Number to Date Format(YYYYMMDD) in Excel

January 17, 2023

If you are facing problems converting numbers to dates in Excel, you are in the right place for a solution. Today, in this article, we will explain ...

5 Ways to Use Formula to Find Next Month in Excel

March 29, 2023

In this lesson, I'll demonstrate 5 effective approaches to how to use Excel formulas for calculating next month including some other problems related ...

7 Simple Ways to Increment Month by 1 in Excel

March 28, 2023

Suppose, you want to list a particular date of every month when you give out the salary of your employees or maybe a list where you calculate your ...

4 Suitable Ways to Add Sequential Dates Across Sheets in Excel

March 20, 2023

Generating data using various formulas is quite common in Microsoft Excel. In the case of creating data separately for sequential dates, it is ...

8 Ways to Calculate Age Using Formula on a Specific Date in Excel

March 20, 2023

Want to Calculate Age on a Specific Date using Excel formula but don’t know how? We are here for you. We have accumulated 8 different methods for you ...