DAYS360:
The DAYS360 function is used to calculate number of days between two dates. But it is based on the assumption that each month in a year has 30 days. This method is adopted in some financial institutions for the calculation of interest and other accounting purposes.
DAYS():
However Excel 2016 version has DAYS() formula which calculates the number of calendar days between two dates.
0 comments:
Post a Comment