Calculating Date Differences easily using Excel days!

News Fetcher2 hours ago

0 0 3 minutes read

The function of days in Excel is the difference in days between two history, ignoring time!

Example of Excel days function

Day function: summary

The days of days are used in Excel to calculate The number of days between two dates. If you have Start date In the cell A1 and The date of completion In the cell B1Formula =DAYS(B1, A1) The total number of days will return between these two history.

If your system is used Mm/dd/yy History format, but your form is used as a different format like DD/mm/yyyyExcel A may appear #value! mistake. This happens because the History coordination does not match the formulaThis caused poor reading of history.

objective	The value that is returned by the job
It aims to return days between two history in the number	You will extract the function of days and return the number of days between the date of the end and the start date.

Days Job: Sentence Building

=DAYS(end_date, start_date)

end_date: The subsequent date.
Start date: Previous date.

Note: The result will be a positive or negative number according to the arrangement of dates.

Job compatibility:

the days The job was presented in Excel 2013. It is supported in all modern versions of Excel, including Excel 2013, 2016, 2019, and Microsoft 365. If you use older versions of Excel, you may need to use the formula: =DATEDIF(start_date, end_date, "d").

Essential example:

S.	The date of completion	Start date	The end result	The formula used	comments
1	March 12	01-jan-24	71	= Days (B4, C4)	It includes February 29, so the year is considered a jump
2	05-jan-23	December 25 -22	11	= Days (B5, C5)	Days between December and Janier, different years
3	June 19, 21	01-aug-21	-43	= Days (B6, C7)	Reverse dates, return a negative number
4	03-Oct-20	05 Sep-20	28	= Days (B8, C8)	In 2020, there is a jump year, but not in February in the range
5	08-may-23	01-jan-23	127	= Days (B9, C9)	Days between two history in the same year
6	June 30 -22	June 15 -22	15	= Days (B10, C10)	Days between two history in the same month and the year

The primary example of the use of days function in Excel

From the above example,

The first shows that days The function automatically works to verify whether the specific dates include a leap year. If so, it adds An additional day For a month February.
The second shows that days The job can be calculated The difference in days Among the dates that occur in Different years.
The third shows that if Previous completion date from Start datethe days The job will return Negative.
The fourth shows that even if leap year Existing, days The job will Ignore it if February He is Not within the range From dates.
The fifth shows that days You can find the job difference Between two dates in The same year.
The sixth shows that days The job can also calculate the difference between two dates within The same month.

In the above example, I tried to cover all the possibilities needed to use the days of days in Excel.

Using other jobs intertwined with days function:

In the example below, I included the available groups for use Day functions With other Excel functions.

attached	The formula used	Output	clarification
Days between	= Days (B7, B4)	546	How many days from start to end
The remaining days	= Days (B7, B10)	-275	The remaining days from today to the end
The case (late)	= If (Days (B10, B7) <0, "OverDue", "on time")	on time	Check if the task is late
Duration text	= Text (days (B7, B4), “0”) and “Days between Start and End”	546 days between the beginning and the end	A sentence of a person who shows the total days
Participation status	= If (Days (B10, B4)> 365, “Exploited”, “Activist”)	Expired	Activity or expired on the basis of 365 days
Months of time	= DATEDIF (B4, B7, “M”)	17	Calculate the full months between dates
Fictional period	= DATEDIF (B4, B7, “Y”) and “Years,” & DATEDIF (B4, B7, “YM”)	One year, 5 months, 29 days	The months and days of remains appear