Excel Date Format Archives

Excel Data Validation for Date Format (4 Suitable Examples)

May 18, 2023

We use Excel in our day to day life. One important aspect while using Excel is that we need to use date and time every now and then. And you may have ...

Excel Data Validation for Date Format (4 Suitable Examples)

Formula for Business Days in Excel (3 Examples)

Feb 12, 2023

Not all 7 days of a week are business days! Business days indicate the working days. In an official week, weekends exist too. Not only that, there ...

Formula for Business Days in Excel (3 Examples)

How to Convert Text to Date with Excel VBA (5 Ways)

Feb 13, 2023

The date is one of the most prevalent issues we all have with Excel, and it's often kept as text elements and gets overlooked at first. Whenever they ...

How to Convert Text to Date with Excel VBA (5 Ways)

How to Convert Date to Year in Excel (3 Quick Ways)

May 26, 2022

When you enter a date in Microsoft Excel, excel automatically recognizes the inserted data and stores it as a date. Besides, you can change the date ...

How to Convert Date to Year in Excel (3 Quick Ways)

How to Convert Date to Day of Week in Excel (8 Methods)

Apr 18, 2023

02/04/2022 represents a date, it does not provide any information of weekdays. But it is equally necessary to know the day of the week. In this ...

How to Convert Date to Day of Week in Excel (8 Methods)

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

May 26, 2022

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 ...

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

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

May 26, 2022

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 Convert Date to Day of Year in Excel (4 Methods)

How to Convert Date to Day in Excel (7 Quick Ways)

Feb 26, 2023

In our day to day life, it is a must that we have to know the day of a certain date. We can easily convert date to day in Excel. For more ...

How to Convert Date to Day in Excel (7 Quick Ways)

VBA to Remove Time from Date in Excel (3 Methods)

Feb 28, 2023

Sometimes there are data in an Excel worksheet that consists of both time and date. Occasionally, we want to get rid of only time or date from that ...

VBA to Remove Time from Date in Excel (3 Methods)

How to Convert Date to Month in Excel (6 Easy Methods)

Feb 28, 2023

This article will show you some interesting ways to convert date to month in Excel. It is one of the easiest tasks in Microsoft Excel. We will be ...

How to Convert Date to Month in Excel (6 Easy Methods)

Excel Formula for Current Month and Year (3 Examples)

May 26, 2022

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 ...

Excel Formula for Current Month and Year (3 Examples)

Remove Time from Date in Pivot Table in Excel (A Step by Step Analysis)

Apr 6, 2022 2

While working with a large Microsoft Excel, sometimes we see that time and date are simultaneously situated in a cell which is a common scenario. We ...

Remove Time from Date in Pivot Table in Excel (A Step by Step Analysis)

Excel VBA: First Day of Month (3 Methods)

May 26, 2022 2

While working with Excel, sometimes we need to know the first day of the given date or month. But there is no direct function or formula in Excel to ...

Excel VBA: First Day of Month (3 Methods)

How to Get the Last Day of Month Using VBA in Excel (3 Methods)

Feb 27, 2023

This article illustrates 3 different methods to get the last day of the current, past, or future month from a specific starting date using VBA code ...

How to Get the Last Day of Month Using VBA in Excel (3 Methods)

How to Change Date Format in Pivot Table in Excel

Feb 13, 2023

Pivot Table, one of the powerful features in Excel, analyzes the larger dataset efficiently. But probably you have faced the problem of date ...