How to subtract dates in excel to get the number of days
- 藏色散人Original
- 2021-03-12 15:47:0961661browse
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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Why is there no 0 in the Excel table?Next article：Why is there no 0 in the Excel table?