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)