Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...

Launch Microsoft Excel. Enter data into the spreadsheet or use existing data from your file. Select the cell you want to place the result Enter the formula Press Enter. Launch Microsoft Excel. Enter ...

Subtraction is the easiest way to count days between two dates in Excel. You can use the arithmetic operator – (minus sign) to subtract one date from another to find the number of days between them.