Team OfficeBeginner

Adding days to a date helps determine deadlines. It can simplify various tasks at hand. For example, completing a task 10 days after the previous task. It is also ‌helpful in stock management, to make sure you don’t sit with old stock. 

4 Methods to add days to a date in Microsoft Excel:

• Add the quantity directly (If the number of days to be added are the same)
• Use a separate column (When the number of days to be added differs)
• Use the Paste Special option
• Use the End of Month formula

Let us begin.

Read more

5 Methods of getting the number of months between two dates:

• Use the YEAR and MONTH function
• Use the MONTH function and subtract the dates
• Use the DATEDIF function
• Use the YEARFRAC and ROUNDUP function
• Use Microsoft VBA code

Let us begin by getting a closer look at these methods.

Read more

Adding months to dates could be very useful.

For example, you have the manufacturing date of multiple products with the number of months they are viable.

You can calculate the expiry date of the product by adding the number of months from the manufacturing date.

This can be done quickly, using MS Excel.

4 Methods to add months to a date using Microsoft Excel:

• Use the EDATE function
• Use the MONTH function
• Use Microsoft VBA code
• Use the Fill Series option

Let us begin by looking at each of these methods in detail.

---

Read more

For calculation and data analysis, you may need to add years to a date in MS Excel. For example, to calculate the date of expiration of goods, to analyze the sales of a company after a period of time or to determine your policy’s payout date.

To do this, MS Excel provides several formulas to make this task easy to execute.

3 Methods to add years to a date in Microsoft Excel:

• Use the YEAR & DATE function
• Use the EDATE function
• Use a generic formula

Let us begin.

---

Read more

If you have a list of people with their dates of birth, it is possible to calculate their age using a few tricks in MS Excel. While there are no specific functions to calculate age in MS Excel, these methods will work just as good.

4 Methods of calculating age from date of birth using Microsoft Excel:

• Use the DATEDIF function
• Use the YEARFRAC function
• Use Microsoft VBA code
• Use the logical formula

Let us begin by looking at how to use these methods to get the age from a person’s date of birth.

Read more

Unlike MS Word, an MS Excel printout seldom looks the same as it is on the screen in front of you. 

For one, you may have a large dataset, and need to know whether everything will fit onto one page, or not, and if so, where the print margins are.

Print Preview helps you understand the layout of your printout, by providing a visual presentation of how your printed copy will look like.

Using this feature, you can customize your printout as per your requirements. You may need to scale the data, shrink the width, or hide a particular row or column to get the desired results.

2 Methods to preview a worksheet before printing in Microsoft Excel:

• Use the Print Preview option
• Use the Page Break Preview option

Let us begin.

Read more