Practical examples on MS Excel date functions
MS Excel has an amazing set of Date and Time functions. By tweaking these functions, we can create a complex and useful formula. I am trying to list down a few practical examples particularly on the Date part, which will be very useful for a moderate to advanced Excel user. How to find the end of the month for a given date Note that EOMONTH will return a serial number. You have to change the format to date format. =EOMONTH(TODAY(),0) =EOMONTH(DATE(2018,10,10),0) How to find the number of days remaining in a month This is useful for interest calculation on first and last month on any type of loan repayment schedule. Use DAYS , EOMONTH, and DATE functions. =DAYS(EOMONTH(TODAY(),0),DATE(2018,10,10)) Number of days remaining in this month or current month =DAYS(EOMONTH(TODAY(),0),TODAY()) Find the number of months between two dates In other words, find the date difference in terms of months. DATEDIF is one of the very ...