Excel Formulas Archives - Page 99 of 149

How to Change Date Format in Excel Using Formula

Jun 23, 2024

To change date format using a formula in Excel: Select a cell. Insert the formula: =TEXT(Reference Cell,"Date Format") Press Enter. For ...

How to Change Date Format in Excel Using Formula

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

Jul 4, 2024

Method 1 - Change the Default Date & Time Format to dd/mm/yyyy hh:mm:ss in Excel When we add a date in a cell of an Excel worksheet, it stores ...

How to Convert a Date to dd/mm/yyyy hh:mm:ss Format in Excel

How to Get First Day of Month from Month Name in Excel (3 Ways)

Nov 11, 2025

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

How to Get First Day of Month from Month Name in Excel (3 Ways)

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

Jul 5, 2024

The sample dataset contains a list of dates in column B. We'll find the last day of the previous month in column C. Method 1 - ...

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

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

Jul 6, 2024

The date format which uses the combination of a year and the number of days since the start of that year is known as Julian Date format. In the 7 ...

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

How to Find Column Index Number in Excel (2 Methods)

Aug 4, 2024

In this tutorial, we will explain some ways to find the Column Index Number in Excel. We'll use the following dataset containing the Painting ...

How to Find Column Index Number in Excel (2 Methods)

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

Jul 29, 2024

Dataset Overview In our dataset, we have information on the Quantity and Sales of various Product Categories, along with Order Dates and ...

How to Count Unique Values in a Filtered Column in Excel (5 Methods)

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

Jul 30, 2024

Method 1 - Use the EOMONTH Function to Calculate the First Day of the Previous Month Step 1: Enter the following formula in cell C5. ...

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

How to Convert Number to Text with Commas in Excel (3 Methods)

Jul 25, 2024

Dataset Overview We will be working with the following dataset to demonstrate these methods. Method 1 - Using FIXED Function The ...

How to Convert Number to Text with Commas in Excel (3 Methods)

How to Count Unique Values in Multiple Columns in Excel (5 Ways)

Nov 11, 2025

There is no easy way to compute the number of unique values in Excel. That's why we need to use formulas and do some manual tasks in Excel to Count ...

How to Count Unique Values in Multiple Columns in Excel (5 Ways)

How to Change Default Date Format from US to UK in Excel (3 Ways)

Jun 14, 2024

Consider the following dataset which represents five nominated movies in the best picture category for the Acadamy Awards (Oscars) in 2022. At first, ...

How to Change Default Date Format from US to UK in Excel (3 Ways)

How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

May 23, 2024

Method 1 - Use the Apostrophe Symbol to Convert Number to Text with 2 Decimal Places in Excel Steps: Put an apostrophe sign (‘) in front of ...

How to Convert Number to Text with 2 Decimal Places in Excel (5 Ways)

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

Jul 29, 2024

Dataset Overview Imagine we have an Excel file containing data about various fruits exported by a businessman to different European countries. The ...

How to Count Unique Values Based on Criteria in Another Column in Excel (4 Methods)

How to Convert Number to Text without Scientific Notation in Excel

Jul 29, 2024

In Excel, if you input a number with 15 or more digits, although the number is stored in number format as usual, it is displayed by default in ...

How to Convert Number to Text without Scientific Notation in Excel

Ways to Count Characters in Cell Without Spaces in Excel: 2 Methods

Jun 28, 2024

Combining LEN and SUBSTITUTE Functions You can use a formula combining LEN and SUBSTITUTE functions to count the number of characters within a cell. ...