Divide by how many months are left until a certain date/month, based on Today's date?

[jjrrcc11]

I have a total figure that I would like to divide by how many months are left to April 2024 based on today's date, to obtain a monthly amount that automatically updates based on the current date.
So for context at present, the figure would be divided by 11, next month it would be 10, etc.

Is there a formula that would achieve this? The total figure is in Cell C13 and I would like to enter the formula in cell Q5.

Even better if an exact date could be used e.g. 5th April 2024.

Many thanks

 

[Sam_D_Ben]

I am not sure if this work for you. Please check.

 

[alansidman]

=C13/DATEDIF(TODAY(),D1,"M") where D1 contains the date 4/5/24

 

[jjrrcc11]

I am not sure if this work for you. Please check.

View attachment 91109

I couldn't get this one to work but I appreciate you taking the time to reply.

=C13/DATEDIF(TODAY(),D1,"M") where D1 contains the date 4/5/24

This worked great. Thank you very much!