Date help?

[Jmusic]

I would like help with dates. Cell A1 has dates, eg. 3/22/2009. In cell B1, I would like a formula to show how many days are in the month (3) of cell A1. B1 would show 31 days. Thanks

 

[Sal Paradise]

Excel Workbook
	A	B
1	14-Apr-09	30
2	24-Jul-09	31
3	22-Oct-09	31
4	28-Feb-09	28
5	10-Aug-09	31
6	25-Oct-09	31
7	24-Feb-09	28
8	26-Mar-09	31
9	20-Mar-09	31
10	19-Feb-09	28
11	30-Jun-09	30
12	11-Feb-09	28
13	04-Nov-09	30
14	18-Sep-09	30
15	09-Apr-09	30
16	26-Nov-09	30
17	30-Dec-09	31
18	12-Mar-09	31
19	01-Aug-09	31
20	22-Feb-09	28
Sheet1

 

[Jmusic]

Thanks for help.