Number of days in a month
Posted by SJC on January 10, 2001 12:26 PM
Is there an Excel function that can give the number of days during a particular month?
In my spreadsheet, I have cell A1 with a value of December 2000. In cell B1, I have a formula that calculates a score involving several variables, including cell A1. Cell A1 will be dynamically changed.
Also, how would you calculate the number of days passed for the month-to-date. For example, for this month, 9 complete days have passed.