Number of days in a month

Originally Posted by mccreaso

Hi All,

Just a quick one. Is there an Excel function that will return the number of days in a month. For example, a cell contains 1/09/2006 in format dd/mm/yyyy, I want to return the value 30 in the next cell as that is how many days are in the month.

Thanks,
mccreaso

Hi,
You will need the Analysis Toolkit Addin to use

=DAY(EOMONTH(11/11/2006,0))

---