DATE Function

How to Get the Current Date in VBA (3 Ways)

In this article, I’ll show you how you can get the current date in VBA in Excel. You’ll learn to show the current date, show the current time, as ...

How to Use WEEKNUM Function in Excel (2 Ways)

In Microsoft Excel, the WEEKNUM function is used to count the week number of a certain year. You can also call this function an Excel TIME and DATE ...

How to Use Excel MONTH Function (6 Examples)

Excel MONTH function is an effective function to extract the month from a given date. This function returns the month as a number between 1 to 12. ...

How to Use YEAR Function in Excel (5 Examples)

We store various dates in the Excel sheet to store any information of any work, projects, or data. By using the YEAR function, you will be able to ...

How to Convert Timestamp to Date in Excel (7 Easy Ways)

A timestamp is a sequence of characters used to specify the date and time of a day. Of course, any specific time or event can be expressed in ...

How to Remove Timestamps from Date in Excel (4 Easy Ways)

Working with Microsoft Excel is great fun. We usually work to process data and get information using MS Excel. When we collect data, we use date and ...

How to Use SUMIFS to SUM Values in Date Range in Excel

To calculate sum values with conditions in a date range is a very common and tricky task in Excel. But Excel has the SUMIFS function to do this job ...

How to Use SUMIFS Formula with Multiple Criteria in Excel (11 Ways)

If you are looking for some of the easiest ways to use the SUMIFS formula with multiple criteria, then you will find this article useful. Sometimes ...

How to Do SUMIF Date Range Month in Excel (9 Ways)

If you are looking for some of the easiest ways to do SUMIF date range month, then you are in the right place. For calculating records of sales or ...

How to Use SUMIFS with Date Range and Multiple Criteria (7 Quick Ways)

Working on Excel, you may often need to sum numbers within specific dates. This article will provide you with 7 quick methods to apply the SUMIFS ...

How to Convert General Format to Date in Excel (7 Methods)

Working with Microsoft Excel's Date format is very common. We use them for various calculations. The Date is one of the essential formats in Excel. ...

How to Convert Text to Date in Excel (10 ways)

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

Convert Number (YYYYMMDD) to Date Format in Excel (4 Methods)

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, ...

How to Convert Number to Date in Excel (6 Easy Ways)

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very ...

Excel Formula to Add Date Range (11 Quick Methods)

Date Range in Excel helps us to do a calculation on date values. In this article, we are going to know more about the Excel Formula for the date ...

ExcelDemy
Logo