I currently have yearly amounts (over several years) that are distributed into monthly values and placed in the correct year. This is based on start and stop dates, which affect the total number of weeks in a given year that the amounts have to be produced within. Now there is another possibility of the end date changing, which would change to total yearly amounts (current and future amounts). I want to reduce the yearly amounts based on the "new possible" end date, only if this "new possible" date is listed in an adjacent column. If it is not listed, then the formula would simply continue as is. This could also eliminate future amounts in future years based on the new date.
I can get the formula to override the current date if there is a "new possible" date listed, but can not figure out how to get the total amount to adjust based on this "new possible" date.
See attachment and thanks very much for any support.
Bookmarks