How do I split a value between two years over a date range in Excel?
This might be more simple than I’m making it, but I have yet to find or create a working function for this problem. I have data for upcoming projects that could begin and end anytime over the next two years, i.e. 2025 & 2026. I know the estimated start date for the project, the expected duration in weeks, and the estimated total cost of the projects.
How do I split a value between two years over a date range in Excel?
This might be more simple than I’m making it, but I have yet to find or create a working function for this problem. I have data for upcoming projects that could begin and end anytime over the next two years, i.e. 2025 & 2026. I know the estimated start date for the project, the expected duration in weeks, and the estimated total cost of the projects.