Hi Firoz

--Suppose you have your data arranged in the below format. Please note that
the months displayed in cell C1, D1 etc; are entries in excel date formats
formatted to display as mmm-yy

Col A Col B Col C Col D Col E
Date In Date Out Jan-09 Feb-09 Mar-09
9-Jan-09 16-Mar-09 23 28 16

--Also note that with the above example there are 23 days inclusive of date-in

--The formula to be applied in cell C2 is given below. Copy the cells to the
right as required

=MAX(0,MIN($B3+1,DATE(YEAR(C$2),MONTH(C$2)+1,1))-MAX($A3,DATE(YEAR(C$2),MONTH(C$2),1)))


If this post helps click Yes
---------------
Jacob Skaria


"Firoz Khan" wrote:

Hi Jacob,
thanks for your reply
it seems my qstn was not clear enough
is it possible to get the result as below ?

Date In Date Out Jan Feb Mar
9-Jan-09 16-Mar-09 22 29 15
where Date In and Date Out is input data and Jan, Feb and Mar are results
is there any formula to get the days of every month for a given period of
time ?
regards
Firoz

"Jacob Skaria" wrote:

Hi Firoz

As in the below example; B1-A1 will do (and format the formula cell to
General)..

Col A Col B ColC
8/1/2009 8/9/2009 =B1-A1
8/1/2009 8/9/2009 =DATEDIF(A2,B2,"d")

If this post helps click Yes
---------------
Jacob Skaria


"Firoz Khan" wrote:

how do I calculate days of every month from a given period (start date and
end date)