How many days does the difference between two dates have? Although there are related software on your mobile phone, how should you quickly calculate the date and time difference between excel? The editor has found two methods, but neither of these methods is counted as the number of days on the first day, so if you need to start from that day, you need to add one. Let’s take a look at the following methods and steps in detail!
Method 1: Subtract to calculate the date and time difference
Step 1: Directly enter "=Last Day-First Day" in the blank cell, and then click the "enter" key to get the last date and time difference.
Warm tip: If you need to start from the first day, just add "+1" to the later one.
Step 2: Use the mouse to place the first calculated date and time difference cell to directly obtain all date and time difference, as shown in the figure below.
Method 2: Use the function to calculate the date and time difference
Step 1: Enter "=DAYS (last day-first day)" in the blank cell, or find the DAYS function in the fx above and enter the relevant data.
Step 2: Pull down the data the same as Step 2 of Method 1 to get all date and time difference.
or more are two methods of excel to calculate the date and time difference . The editor believes that the first method may be easier to remember, and everyone can subtract it, but the second method is still very convenient to use, so it is used according to personal preference. How many days does the difference between the two dates? After reading this article, you can calculate it quickly!
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-