“DAYS”
Used for – “DAYS” function in MS Excel is
used to find the total nos. of days in between two dates. Simply, you can also
says it is a way to tell excel to treat two dates as nos. of days from one
reference and perform the subtraction to find out total no. of days in between
two dates.
Syntax – DAYS(end_date, start_date)
end_date – It is any date/reference cell (only if it contains a number or date), you typed or calculated from which you wants to subtracts other date to find the total no. of days. It is compulsory field and if you did not fill any value excel consider it as 0 and does not give any error.
start_date – It is any date/reference cell (only if it contains a number or date), you typed or calculated which you needs to subtracts from the earlier date. It is also a compulsory field and if you did not fill any value excel consider it as 0 and does not give any error.
end_date – It is any date/reference cell (only if it contains a number or date), you typed or calculated from which you wants to subtracts other date to find the total no. of days. It is compulsory field and if you did not fill any value excel consider it as 0 and does not give any error.
start_date – It is any date/reference cell (only if it contains a number or date), you typed or calculated which you needs to subtracts from the earlier date. It is also a compulsory field and if you did not fill any value excel consider it as 0 and does not give any error.
Example – Following example will clear
the DAY function:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
14-08-2016
|
=DAYS(A2,A1)
|
|||||||
2
|
14-05-2017
|
||||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
14-08-2016
|
273
|
|||||||
2
|
14-05-2017
|
||||||||
3
|
|||||||||
4
|
|||||||||
5
|
|||||||||
6
|
|||||||||
7
|
Here
Cell B1 is showing the result of DAYS function when it is used for find out difference
between two dates.
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.