DATE Function

Split Date and Time Column in Excel (7 Easy Methods)

If you have a date and time in the same cell and need to separate them into two different columns, you are in right place! In this article, I will ...

How to Calculate Difference Between Two Dates in Days in Excel

We’ll show you 7 quick methods of how to calculate the difference between two dates in days in Excel. To demonstrate our methods, we’ve picked a ...

How to Separate Date in Excel Using Formula (5 Suitable Ways)

Separating dates from different parts of the text or time is one of the most common uses of Excel.  Also extracting day month and year from part of ...

Formula to Hide Rows in Excel (7 Methods)

In Excel, while we want to view as many rows or information as possible, at the same time we want to hide some of the unimportant rows. Maybe because ...

How to Calculate Percentage of Month in Excel (4 Ways)

Assume you have a set of dates in a spreadsheet and want to know what percentage of the year or month has passed or remains based on the given date. ...

How to Generate Random Date and Time in Excel (3 Ways)

For many demonstration or experimental purposes, you may want to fill up Excel columns with random dates and times. You of course can fill those ...

How to Insert Date in Excel Formula (8 Ways)

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follows this pattern. You can write dates ...

How to Sort Birthdays by Month and Day in Excel (5 Ways)

If you are looking for some of the easiest ways to sort birthdays in Excel by month and day, then this article will be helpful for you. Grouping ...

Excel Interest Only Amortization Schedule with Balloon Payment Calculator

In this tutorial, we will explain how to calculate an interest-only amortization schedule with a balloon payment calculator in excel. We will develop ...

Get the First Day of the Current Month in Excel (3 Methods)

Microsoft Excel offers a handful of methods to get the first day of the current month. You can also get the first day of any random month or for the ...

How to Convert Date to Day of Year in Excel (4 Methods)

While working with dates in Excel, we occasionally need to convert dates to day numbers or names. Also, to count day differences we convert date to ...

How to Apply Multiple Data Validation in One Cell in Excel (3 Examples)

In this tutorial, we will demonstrate how to apply multiple data validation in one cell in excel. If you work regularly on Microsoft Excel it may ...

Excel Formula for Current Month and Year (3 Examples)

While you are working in Excel you may not always need the full date in some cases because the full date takes more space and may be unnecessary. So ...

How to SUMIF between Two Dates and with Another Criteria (7 Ways)

If you are looking for some of the easiest ways to SUMIF between two dates and another criteria, then you will find this article useful. Adding up ...

How to Use Formula to Change Date Format in Excel (5 Methods)

In this article, we’re going to show you 5 methods of how to change Date format in Excel Using formula. Our sample dataset contains data of 6 people. ...

ExcelDemy
Logo