Suppose, you have been given a date say 15-Nov-14 and you have to determine how many days this particular month contains.
The formula which you need to use in the above case would be
=DAY(EOMONTH(A1,0))
Explanation – EOMONTH(A1,0) gives the last date of the month and DAY function extract that particular Day from the last date of the month.