Pls help to find number of days for ageing report

[pol]

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

 

[Fred Smith]

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

Regards,
Fred.

 

[Ms-Exl-Learner]

Use Datedif function.

=DATEDIF(B1,A1,"D")

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

Remember to Click Yes, if this post helps!

 

[Jacob Skaria]

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

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