How to subtract dates in excel to get the number of days

How to get the number of days by subtracting dates in excel: first open the Excel table file; then set the cell value format to "date type"; finally, use the formula "B1-A1" and click on the cell to set it to "Numeric type", click "OK".

The operating environment of this article: windows7 system, Microsoft Office Excel2003, DELL G3 computer

Your cell value must be in the format of "date type" ", then B1-A1, click the cell to set it to "Numeric type". As shown below:

# Click OK, OK!

[Recommended learning: Excel tutorial]

The above is the detailed content of How to subtract dates in excel to get the number of days. For more information, please follow other related articles on the PHP Chinese website!