Formula required for # of days Calculation


N

Narnimar

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.
 
Ad

Advertisements

M

Mathew P Bennett

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
 
D

David Biddulph

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?
 
Ad

Advertisements

N

Narnimar

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top