![]() ![]() ![]() If the dates could be before or after today's date, enter either of the above formulas and wrap the formula in the ABS function to eliminate any potential negative sign: =ABS(TODAY()-B4). Or perhaps you'd like to learn just one formula for calculating the number of days between today's date and worksheet dates. Showing negative numbers in this situation would be unattractive at best and misleading at worst, but we have a fix. ![]() That will help them better understand the worksheet data and the formula results. The serial number of a date in the future will always be larger than today's date, so the future date goes first in the subtraction formula.Įxpert Tip: Place the TODAY function in a worksheet cell near the worksheet title so someone looking at a printed copy of the sheet will know the date it was printed. Why does this work? Excel stores dates in ever-increasing serial numbers. If the Excel returns an odd-looking date for the formula result, open the Format Cells dialog box and format the cell as Number. Writing the formula this way will insure that the formula will not display a negative result. Since the worksheet dates in column B are in the future, their serial numbers will be greater than the serial number of today's date. If you know that all of the worksheet dates will all be in the future, then subtract today's date from the worksheet date.Īs seen in the formula bar, we entered =B4-TODAY() in cell C4. As you autofill (or copy and paste) down the column, the other formulas will return a number result as well. Expert Tip: Before you begin, pre-format the cell that will hold your first formula in a number format. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |