Count of number of days in month

[blazer12219]

Have field called [Off Contract Date] the value is 04/28/22

I need a formula to count number of days elapsed in that particular month so answer should be 28 in the example above but this field is variable and will change, field called [PartialBillingDays]

Next would like to create a field called [PartialBilling%]  formulated by dividing (28) or [PartialBillingDays] / the number of days in the month represented in [Off Contract Date] or Date.DaysinMonth([Off Contract Date]) 

So in this example the math would be 28 / 30 = .9333%

I can get the PartialBilling% to work but just cannot find the correct formula to cover the PartialBillingDays amount.

[blazer12219]

I figured out the error I included a % in name description

[blazer12219]

I get an error message with that formula

if checked to make sure the field was set to a date type {"Off Contract Date", type date}

Any thoughts?

[Vijay_A_Verma]

Can you click on the error and paste the message here? 

[Vijay_A_Verma · Accepted solution]

Use following formula for PartialBillingDays

= Date.Day([Off Contract Date])