1. What is the formula for calculating the elapsed number of days to return
in c1 for any selected value which is in a cell a1 and a given date in b1.
2. What is the formula for calculating the elapsed number of days to return
in c2 for any selected value which is in a cell a2 where the day to be
continued from the c1.

Try

=C2-C1

Format as general.

Mike

"Narnimar" wrote:

1. What is the formula for calculating the elapsed number of days to return
in c1 for any selected value which is in a cell a1 and a given date in b1.
2. What is the formula for calculating the elapsed number of days to return
in c2 for any selected value which is in a cell a2 where the day to be
continued from the c1.

Since there is a hidden criteria to be considered like no of days of the
month and continued month also, I did not get the right figure by applying
simple formula. Kindly see below-
Month If value Avg 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
For my question no.1
If Value a1= 1200 so, 4 days are in Sep + 7.2 days will have to be accounted
to Oct.

For my question no.2
If Value a2= 4800 so, 46.46 days (because =7.2 days Oct + 23.8 days
Oct + 15.46 days nov)
Any further if need please revert back. Thanks you so much for helping.

"Mike H" wrote:

Try

=C2-C1

Format as general.

Mike

"Narnimar" wrote:

1. What is the formula for calculating the elapsed number of days to return
in c1 for any selected value which is in a cell a1 and a given date in b1.
2. What is the formula for calculating the elapsed number of days to return
in c2 for any selected value which is in a cell a2 where the day to be
continued from the c1.