Hello!

I'm looking for help to come up with an excel formula to help me figure out how many days are in a month based on a date entered.

In B1 I have the delivery date.
In B2 I would like to have a formula that will tell me how many days of pro-rated rent.

B1: 10/9/2017
B2: 23

I tried using EOMONTH but this is giving me a total value of the month of October when I want to know how many days are between the 9th and the 31st. I also want to make sure that that end result counts the day and will account for the fluctuation in the days of the month.

Any help is appreciated.

Thanks!