Nov | search
Click here to view Nov news from 60+ newspapers.
Bookmark or Share- DATEVALUE function - Microsoft SupportThe DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE ("1/1/2008") returns 39448, the serial number of the date 1/1/2008.
- Create or delete a custom list for sorting and filling dataCreate a list of sequential dates. Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list.
- Detect errors in formulas - Microsoft SupportFormulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine solutions. Note: This topic contains techniques that can help you correct formula errors.
- Convert times - Microsoft SupportHere are several ways to convert time units, such as how many hours there are in 5.5 days, how many days there are in 3.45 years, or how many months are between a beginning and an ending date. Convert between time units. Convert a standard time format to a decimal number. Convert from a decimal to the standard time format. Need more help?
- NPV function - Microsoft SupportThis article describes the formula syntax and usage of the NPV function in Microsoft Excel. Description. Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values). Syntax. NPV (rate,value1, [value2],...)
More
