Excel Basics

How to Add 30 Days to a Date in Excel (7 Quick Methods)

In Microsoft Excel, by using different functions you can easily add 30 or any number of days to a particular date. In this article, you'll learn a ...

Reference Operator in Excel [Basics + Special Uses]

It is highly unlikely that you'd be an Excel user without having heard of reference operators. We use these essential operators frequently. And this ...

Excel Increment Month by 1 [6 Handy Ways]

In some cases, we have to find the date after incrementing 1 month. Do you know the easiest ways and functions to do that? In this article, I’ll ...

How to Add a 1 in Front of Numbers in Excel [7 Special Tricks]

You may attach a special type of number like 1 before the local phone number of the US to make it an international identity. It is also mentionable ...

Excel Add Months to Date (4 Easiest Examples)

For project planning or time management, we need to make a routine or schedule. Making time schedules, MS Excel provides different ways to add months ...

How to Use COUNTIF to Count Cells Greater Than 0 in Excel

COUNTIF function is one of the most basic & simple operations in MS Excel that can be used to count 0(Zero), greater than 0 or less than 0 under ...

Excel Formula to Count Days from Date to Today (8 Effective Ways)

Counting the number of days in Excel is a significant task in our day-to-day activities. But what are the Excel formulas to do that in an efficient ...

Excel 2 Decimal Places without Rounding (4 Efficient Ways)

Sometimes we may need to get values up to two decimal places. There are several ways to do that. In this article, I will show how to get two decimal ...

Excel Text Function Format Codes

Text function is one of the meaningful functions in Excel that allows you to do different formatting types or numbers. This article will show various ...

Excel Number Stored As Text [4 Fixes]

Once you input any data for example a number, it will be stored typically as a number. Later, we can use and manipulate the number for analysis. ...

How to Add Text before a Formula in Excel (4 Simple Ways)

For better understanding and visualization sometimes, we need to add text in front of an Excel formula. In this article, I will show how to add text ...

Add or Keep Leading Zeros in Excel (10 Suitable Ways)

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros ...

How to Update One Excel Worksheet from Another Sheet Automatically

Provided that you have prepared a worksheet on your workbook and you want to utilize it in another sheet. In this situation, you can unconsciously ...

Excel Formula to Calculate Number of Days Between Today & Another Date (6 Quick Ways)

Do you want to calculate the number of days between today and the other date? You can easily compute the number of days using Excel. In this ...

How to Use Conditional Formatting in Excel Based on Dates

Conditional formatting has been used in Excel for quite some time now. But what is conditional formatting, and how can it benefit you? The process of ...

ExcelDemy
Logo