Need calculation help

Hi 

I am looking to calculate when a member joins a member the club. 

Example: 

If a user joins in the month of November and the the membership ends on May 31. I want to use a prorate feature that charges $10 per a month and adds 25 on the initial date of joining.

I was advised to use this 

https://www.jotform.com/help/268-How-to-Insert-Text-or-Calculation-into-a-Field-Using-Conditional-Logic

I need your minds on this one. 

Is the month has a dropdown option or it should be selected on datepicker? Please further explain your requirements so we can make a workaround and demo form for you.

If the month is based on the date that the user chooses with datepicker then I'm afraid we need to calculate it by days to determine how many months is the membership.

We'll wait for your response.

The date is when the user opens the form and choose prorated 

The end date is May 31. 

Calculation is 

If a person is looking to join in Nov then the calculation should be any amount per a month until May 31st. 

I see. So the end date is fixed May 31st.

Could you please check this demo form: https://form.jotform.com/90787314577974.

I calculate the days between the current date and end date then divide it to 30 to get the number of months. I cannot find a function that gives the number of Days of a Month so you will need to either assume a fixed 30/31 days and calculate.

Could you please explain the calculation (formula) to us?

Ok I am trying something new with the calculations.  Still the same issue, but just a new way of calculating.  I am using the localized calendar and right now the dates I am picking to make sure the form is calculating properly. I am not getting the numbers below when I change the dates. I need help?

https://form.jotform.com/90978502195163

Hello,

Firstly, I would suggest to combine conditions using 'ALL' rule. Also, Date is not equal to any month particularly, please try checking if Date 'contains' every month value instead of 'is equal'. Here is a sample condition:

@tim.nollan25,

If you are experiencing any issue with your forms, we request you to open a new thread and provide us with the form ID/URL so that one of our support team members can assist you.

Thanks!

Victoria's answer did not work. 

Still looking for help

Give me more time to check this. I will update you via this thread.

Sorry for delayed response. I checked the calculation and the months that did not work as expected is these:

June  
July  
August  
September
October
November

Please check your calculation condition, those months did not show expected results because the calculation was incomplete.

Your new question will be addressed in the following thread: https://www.jotform.com/answers/1794102-