# Calculate number of days in a month from a single date

#### Mldeuser

##### Well-known Member
I am trying to calculate the number of days in a given month from a single date. For example cell D72 has the date 08/12/2011 in L72 I need to calculate the number of days in the month of August.

Is there a simple formula that can do this.

Thank you

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Trh this formula:
=DAY(EOMONTH(D72,0))

Try:
Excel Workbook
AB
18/12/20118/31/2011
Sheet2

Following on from GTO, the formula to get just the number of days of the month is

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

Replies
2
Views
184
Replies
2
Views
98
Replies
2
Views
418
Replies
3
Views
180
Replies
3
Views
108

1,207,390
Messages
6,078,204
Members
446,321
Latest member
thecachingyeti

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