Calculating a YTD Balance based on end date?

I am sure that what you want is possible, but it's a little unclear exactly what you need.

"Year to date" means from January 1 of this year until today. That is not what you're describing.

It sounds like you want to calculate <something> from today until December 31, 2026.

It's not clear what you want to calculate. You have thrown some numbers out there but it's not clear what you want to do. Are you trying to build a timeline of a budget for what you want your account balance to be, with a goal of having it reach $5000 by December 2026? And the number of 24 months is wrong, because November 2024 to December 2026 inclusive is 26 months.

And you just want a single number, based on today's date? And you also have to specify the starting date.

Values as displayed

	A	B
1	Goal	$5,000.00
2	Target Date	12/1/2026
3	Start Date	11/1/2024
4	Months	26
5	Monthly Target	$192.31
6	Months Elapsed from Start	1
7	Target to Date	$192.31
Balance Budget

Underlying formulas

	A	B
1
2
3
4		=DATEDIF(B3,B2,"m")+1
5		=B1/B4
6		=DATEDIF(B3,TODAY(),"m")+1
7		=B5*B6

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Did you see the Moderator's notice in post #3?