Excel uses DateValue to calculate the number of days between the loan date and the repayment date

When an enterprise lends to banks and individuals, to calculate the number of days between the loan date and the repayment date in Excel, Excel2007 can use the DateValue function to calculate the number of days between the loan date and the repayment date.

As shown in the figure above. Enter the formula in the C2 cell:

=datevalue ("2011-6-8")-datevalue ("2010-9-8")

Press ENTER to calculate the number of days between the loan date and the repayment date based on the repayment date and the loan date.

Excel2007 can use the DateValue function to calculate the number of days between the loan date and the repayment date.

Related instructions:

DATEVALUE function Syntax: DATEVALUE (Date_text)

Date_text represents the text of a date that is represented in Microsoft Excel date format. For example, "2008-8-8" or "30-jan-09" is the quoted text, which is used to represent dates.

If you omit the year portion of Date_text, the function DATEVALUE uses the current year of the internal clock in the computer system. The time information in the Date_text will be ignored.

The DateValue function returns the serial number of the date represented by Date_text. The main function of the function DATEVALUE is to convert the date represented by text into a serial number.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join