Do you use Excel spreadsheets to keep track of your weekly, monthly or annual expenses but find yourself updating all relevant date and content information manually? There is an easier, more effective ...

This tutorial will show you how to create a Formula to Add, Subtract, Multiply or Divide in Microsoft Excel. You can do basic calculations easily!

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory ...

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

How to extract the date in Excel You’ll often work with date values that have no decimal value or time values. When the two are combined into one value, such as 44292.0412, they can be difficult ...

To ensure that Excel converts your date to a number enter it like this, without quotes: "4/4/2011". Then click on cell "A2" and enter the later of the two dates in the same manner.

Select the dates, then go to the Formula ribbon and pick Define Name (Excel 2010) or Defined Names > Define Name (Excel 2016). (For more on named ranges, read JD Sartain’s detailed how-to.) ...

Here’s how to set up a formula with WEEKNUM: 1. Enter 10 or 12 random dates in cells A4 to A15. 2. Move your cursor to B4. Go to Formulas > Date & Time and select WEEKNUM from the dropdown list.

If you’re using Excel 2003, you can’t convert your list of holidays into a Table, so you’ll have to use a dynamic range or update your NETWORKDAYS () function if you add new holiday dates.