Tuesday, 10 November 2015

Blog No - 52 - FunctionS in Excel (Days360) & Happy Diwali

Today's topic is Days360 function. We will learn how it works and what the argument is require.

Days360 function returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.

Days360 require three arguments

1)      Start Date
2)      End Date
3)      Method (This is an optional and logical value which specifies whether to US or Europe method in calculation. False means US and True means Europe)






Keep Learning & Happy Diwali
Sanjay Bakshi
mesanjaybakshi@gmail.com





No comments:

Post a Comment