S
Simon Shaw
I have a monthly budget. I want to translate that into an amount for each day
of the year. However, I do not want the amount each day to simply be the
monthly amount divided by the number of days in the month. Rather I want to
calcuate the amounts for each day as if they followed a smooth curve for the
year. So if say the daily amounts were line graphed, it would be smooth.
I am familiar with formulas from all types, but I can't find one that would
do something like this. Is it a mathematical formula?
Next I want to be able decide which days in the year are not going to be
worked, so that I can zero out the day, with that amount is spread back over
the other amounts.
of the year. However, I do not want the amount each day to simply be the
monthly amount divided by the number of days in the month. Rather I want to
calcuate the amounts for each day as if they followed a smooth curve for the
year. So if say the daily amounts were line graphed, it would be smooth.
I am familiar with formulas from all types, but I can't find one that would
do something like this. Is it a mathematical formula?
Next I want to be able decide which days in the year are not going to be
worked, so that I can zero out the day, with that amount is spread back over
the other amounts.