DATE Function

How to Get Last Day of Previous Month in Excel (3 Methods)

Sometimes, we may need to know the dates for the last day of the present, earlier, or any other month on a regular basis. We can easily get any day ...

How to Convert 7 Digit Julian Date to Calendar Date in Excel (3 Ways)

Often, food manufacturers, pharmaceutical companies, and different other sectors use the Julian Date format in their products. But this date format ...

How to Calculate First Day of Previous Month in Excel (2 Methods)

If you are working with dates in Excel, you might need to find out the first day of the month before the current month you are working with. In ...

How to Create an Excel Formula to Subtract (10 Examples)

Subtraction is a common operation in mathematics. In Microsoft Excel, we don't have any built-in function for subtraction. We will show how to create ...

How to Create a Formula in Excel to Change Date by 1 Year (3 Methods)

In this tutorial, we will learn how to create a formula in excel to change the date by 1 year. While you are working with date type information you ...

How to Calculate Remaining Days in Excel (5 Methods)

While working with a project in Excel that has a deadline to meet, you might want to find out how many days from today are left until the deadline. ...

How to Calculate Percentage of Time in Excel (4 Suitable Examples)

In this tutorial, I will show you how to calculate the percentage of time in excel using the basic percent formula. Besides, I will show some ...

How to Calculate Accrued Interest on a Bond in Excel (5 Methods)

The accrued interest on a bond is specified as the amount of earning on a debt. Here, the bond is considered to be a debt. And when the owner of a ...

How to Convert Unix Timestamp to Date in Excel (3 Methods)

This article explains 3 methods to convert Unix timestamp to date in Excel. The Unix timestamp format is widely used in different operating and file ...

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

The timestamp of Active Directory is illegible to humans. Fortunately, Excel provides the opportunity of transforming the timestamp to readable ...

How to Convert SAP Timestamp to Date in Excel (4 Ways)

If you are looking for some of the easiest ways to convert SAP Timestamp to date in Excel easily, then you will find this article useful. SAP ...

How to Convert Week Number to Date in Excel (2 Suitable Methods)

In Microsoft Excel, working with week and date is one of the crucial tasks. You will find yourself in a lot of situations where you will have to find ...

How to Calculate Accrued Interest on Fixed Deposit in Excel (3 Methods)

Excel is an obvious tool for our day-to-day activities. We can largely bank on Excel for a myriad of purposes that involve calculations. For ...

How to Calculate Dividend Growth Rate in Excel (3 Methods)

While doing stock valuation, you need to find the dividend growth rate for accomplishing a better decision. Interestingly, you can compute the growth ...

How to Calculate Accrued Interest on a Loan in Excel(3 ways)

The amount of interest you earn on a loan is known as accrued interest. It is, however, the Sum that has yet to be collected or paid. It accrues on ...

ExcelDemy
Logo