Pls help to find number of days for ageing report
 

if the cell A1 = 30-Nov-2009 and cell b1 01-Nov-2009

How I can find the number of days between that date. It is for ageing
analysis for customers

Pls help

Pls help to find number of days for ageing report
 

It's simply:
=a1-b1
Format as a number

Regards,
Fred.

"pol" wrote in message
...
if the cell A1 = 30-Nov-2009 and cell b1 01-Nov-2009

How I can find the number of days between that date. It is for ageing
analysis for customers

Pls help

Pls help to find number of days for ageing report
 

Use Datedif function.

=DATEDIF(B1,A1,"D")

=DATEDIF(B1,A1,"D")&" Days"

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"pol" wrote:

if the cell A1 = 30-Nov-2009 and cell b1 01-Nov-2009

How I can find the number of days between that date. It is for ageing
analysis for customers

Pls help

Pls help to find number of days for ageing report
 

Simple substration will do. In cell C1 enter the below formula

=A1-B1
(and format cell C1 to general)

--
Jacob


"pol" wrote:

if the cell A1 = 30-Nov-2009 and cell b1 01-Nov-2009

How I can find the number of days between that date. It is for ageing
analysis for customers

Pls help