Pls help to find number of days for ageing report

  • Thread starter Thread starter pol
  • Start date Start date
P

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
 
Use Datedif function.

=DATEDIF(B1,A1,"D")

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

Remember to Click Yes, if this post helps!
 
Simple substration will do. In cell C1 enter the below formula

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