DAYS360

DAYS360

No Comments

“DAYS360”

Used for – “DAYS360” function in MS Excel is also used to find the total nos. of days in between two dates but based on the theory of 12 months each having 30 days and a year has total 360 days.

Syntax – DAYS360(start_date, end_date, [method])
             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.
            [method] – It is an optional field and used to define two different methodology one is U.S. (NASD) method and other is European method. Here true or false is used to defined European or U.S. (NASD) methods to be followed, respectively.  

Example – Following example will clear the DAY function:-

A
B
C
D
E
F
G
H
I
1
01-08-2016
=DAYS360(A1,A2)







2
31-05-2017
=DAYS360(A1,A2,False)







3

=DAYS360(A1,A2,True)







4









5









6









7










And result you get as under:-

A
B
C
D
E
F
G
H
I
1
01-08-2016
300







2
31-05-2017
300







3

299







4









5









6









7











Here Cell B1, B2 & B3 is showing the result of DAYS360 function when it is used without method , with US (NASD) method and European method respectively, for find out difference  between two dates.
DAYS

DAYS

No Comments

“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.

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.

Is this article helpful to you?

Amazon