calculate monthly value

BrutalLogiC

Active Member
Joined
Feb 26, 2006
Messages
274
Office Version
  1. 365
Platform
  1. Windows
Hi I hope someone can help me with calculating the monthly values. I have lots of contracts and most are a fixed value for the full year but for some the value changes which makes it complicated for me to track the monthly values.

For part months I am dividing latest annualised total by 365 days.

Original start dateOriginal annualised valueOriginal MonthlyOriginal DailyVariation 1 start dateV1 annualied valueV1 MonthlyV1 DailyVariation 2 start dateV2 annualised valueV2 MonthlyV2 DailyVariation 3 start dateV3 annualised valueV3 MonthlyV3 DailyEnd Date
1-Jan-202315,000,0001,250,00041,09630-Mar-202412,000,0001,000,00032,87730-Jun-202413,000,0001,083,33335,6161-Nov-20248,500,000708,33323,28815-Dec-2024

so in words the values would be as below but I have been struggling to figure out formula to replace the words below which consider any variations. Appreciate any help!!!

Monthly values​
Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-242024 total
original monthly valueoriginal monthly valuethis would be 29 days at the original daily value and 2 days at V1 valueV1 monthly valueV1 monthly valuethis would be 29 days at V1 value and 1 day at V2 valueV2 monthly valueV2 monthly valueV2 monthly valueV2 monthly valueV3 monthly valueV3 15 days only!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,224,811
Messages
6,181,080
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top