# Date help?

#### Jmusic

##### Board Regular
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

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Excel Workbook
AB
114-Apr-0930
224-Jul-0931
322-Oct-0931
428-Feb-0928
510-Aug-0931
625-Oct-0931
724-Feb-0928
826-Mar-0931
920-Mar-0931
1019-Feb-0928
1130-Jun-0930
1211-Feb-0928
1304-Nov-0930
1418-Sep-0930
1509-Apr-0930
1626-Nov-0930
1730-Dec-0931
1812-Mar-0931
1901-Aug-0931
2022-Feb-0928
Sheet1

Thanks for help.

Replies
5
Views
165
Replies
3
Views
332
Replies
2
Views
150
Replies
4
Views
491
Replies
11
Views
585

1,191,501
Messages
5,986,922
Members
440,067
Latest member
Swatts1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back