Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
MS Excel Articles
Page 119 of 119
How to Add and Subtract Dates and Times in Excel?
Changing the dates on a spreadsheet can be a time-consuming process. You can change the dates without having to get out your calendar to count the days or months because you can do so directly in Microsoft Excel by using basic addition or subtraction.Adjusting the dates does not have to be a burden, regardless of whether this is a project schedule with due dates, a budget with dates when bills are due, or an order sheet with shipment dates. You can enter the addition or subtraction, and the new dates will be automatically calculated for you after a few straightforward ...
Read MoreHow to Convert Multiple Rows to Columns in Excel?
Let's assume you already have a list of data with many rows that only has one column in an excel sheet, but you want to convert these data to multiple rows and columns, you can achieve this using an Excel formula.Step 1Let’s consider the following list of multiple rows data and try to convert those data into multiple columns and rows using excel formula.Step 2Let’s choose an empty cell (C1) in which we will store the first data of the list of data and type the following formula in cell C1 and press Enter.=OFFSET($A$1, (ROW()-1)*3+INT((COLUMN()-3)), MOD(COLUMN()-3, 1))Step 3Now we get ...
Read More