Formula required for # of days Calculation
 

Suitable formula required to retun the no of days when spreading an available
value + receivables based on monthely budget limit from a chosen date to
remainder days of the months and reminder months of year so on.
The formula should work under the criteria of monthly budget value limit as
per the e.g below and no of days in the months, accounting start date and end
dates of the subsequent receivables values.

Month Limit Daily Avg. based on total month days
Sep-08 2900 96.67
Oct-08 3500 112.9
Nov-08 3200 106.67
Dec-08 2900 93.55
Jan-09 3000 96.77
Feb-09 3200 114.29
Mar-09 2900 93.55
Apr-09 3000 100
May-09 3200 103.23
Jun-09 2900 96.67
Jul-09 3000 96.77
Aug-09 3200 103.23

E. g. as on Date : 27-sep-2008 Days Spread

AvailableValue1 1200 4 days remaining from the date in Sep
ReceivableValue2 4800 46.46 days (=7.2 + 23.8 + 15.46 days) Not sure if I
am right

Hope excel will have some solution to this. Any help is highly appreciated.

Formula required for # of days Calculation
 

Try Using DATEDIF function.
It is not in the help file, sorry I do not have time to try it out for you,
but Google it & you should be ok.
Mathew
"Narnimar" wrote in message
...
Suitable formula required to retun the no of days when spreading an
available
value + receivables based on monthely budget limit from a chosen date to
remainder days of the months and reminder months of year so on.
The formula should work under the criteria of monthly budget value limit
as
per the e.g below and no of days in the months, accounting start date and
end
dates of the subsequent receivables values.

Month Limit Daily Avg. based on total month days
Sep-08 2900 96.67
Oct-08 3500 112.9
Nov-08 3200 106.67
Dec-08 2900 93.55
Jan-09 3000 96.77
Feb-09 3200 114.29
Mar-09 2900 93.55
Apr-09 3000 100
May-09 3200 103.23
Jun-09 2900 96.67
Jul-09 3000 96.77
Aug-09 3200 103.23

E. g. as on Date : 27-sep-2008 Days Spread

AvailableValue1 1200 4 days remaining from the date in Sep
ReceivableValue2 4800 46.46 days (=7.2 + 23.8 + 15.46 days) Not sure if I
am right

Hope excel will have some solution to this. Any help is highly
appreciated.

Formula required for # of days Calculation
 

If you are counting number of days, I can't see how DATEDIF helps. Wouldn't
simple subtraction do just as well?
Isn't it only when dealing in months and years that you need DATEDIF,
Matthew?
--
David Biddulph

"Mathew P Bennett" wrote in message
...
Try Using DATEDIF function.
It is not in the help file, sorry I do not have time to try it out for
you, but Google it & you should be ok.
Mathew
"Narnimar" wrote in message
...
Suitable formula required to retun the no of days when spreading an
available
value + receivables based on monthely budget limit from a chosen date to
remainder days of the months and reminder months of year so on.
The formula should work under the criteria of monthly budget value limit
as
per the e.g below and no of days in the months, accounting start date and
end
dates of the subsequent receivables values.

Month Limit Daily Avg. based on total month days
Sep-08 2900 96.67
Oct-08 3500 112.9
Nov-08 3200 106.67
Dec-08 2900 93.55
Jan-09 3000 96.77
Feb-09 3200 114.29
Mar-09 2900 93.55
Apr-09 3000 100
May-09 3200 103.23
Jun-09 2900 96.67
Jul-09 3000 96.77
Aug-09 3200 103.23

E. g. as on Date : 27-sep-2008 Days Spread

AvailableValue1 1200 4 days remaining from the date in Sep
ReceivableValue2 4800 46.46 days (=7.2 + 23.8 + 15.46 days) Not sure if
I
am right

Hope excel will have some solution to this. Any help is highly
appreciated.

Formula required for # of days Calculation
 

Hi Mathew, thanks for your response. for your information I am a user only
know little but eager to make use excel formulas feature.
Any body can kindly help me??

"Mathew P Bennett" wrote:

Try Using DATEDIF function.
It is not in the help file, sorry I do not have time to try it out for you,
but Google it & you should be ok.
Mathew
"Narnimar" wrote in message
...
Suitable formula required to retun the no of days when spreading an
available
value + receivables based on monthely budget limit from a chosen date to
remainder days of the months and reminder months of year so on.
The formula should work under the criteria of monthly budget value limit
as
per the e.g below and no of days in the months, accounting start date and
end
dates of the subsequent receivables values.

Month Limit Daily Avg. based on total month days
Sep-08 2900 96.67
Oct-08 3500 112.9
Nov-08 3200 106.67
Dec-08 2900 93.55
Jan-09 3000 96.77
Feb-09 3200 114.29
Mar-09 2900 93.55
Apr-09 3000 100
May-09 3200 103.23
Jun-09 2900 96.67
Jul-09 3000 96.77
Aug-09 3200 103.23

E. g. as on Date : 27-sep-2008 Days Spread

AvailableValue1 1200 4 days remaining from the date in Sep
ReceivableValue2 4800 46.46 days (=7.2 + 23.8 + 15.46 days) Not sure if I
am right

Hope excel will have some solution to this. Any help is highly
appreciated.