Excel - counting days

PoodlePoodle Experienced MentorRegistered Posts: 711
Hi

I know how to use the DAYS360 function in excel but is there a formula for counting actual days between two dates when there are 31 days in a month?

I would like to create a manual aged debtor report.

Thanking you

Poodle

Comments

  • msfmsf Settling In Nicely Registered Posts: 22
    hi Poodle,

    If an aged report was being produced say on (a) 30 April and invoices dated say (b) 1 Feb. I would use the sum function, take the cell (a) less cell (b) and +1 ie sum(a-b)+1 = 90 days, this would solve the days issue.

    hope this helps....
    manaf
  • CJCCJC Font Of All Knowledge Registered Posts: 1,657
    Just use minus, Excel will figure the number of days in the month and even deals with leap years.

    E.g. =26/02/2008 - 1/03/2008 returns 4

    If you just wanted working days use =networkdays(startDate, endDate[,holdays])
  • PoodlePoodle Experienced Mentor Registered Posts: 711
    Thank you both for your help
  • Nilesh MandviaNilesh Mandvia Feels At Home Registered Posts: 91
    Have you tried EDATE formula? If you are doing manual aged debt, this may help to generate dates for the next month, month after.

    =EDATE(01/01/08,1) would give you the resul of 01/02/08. This way if you wish you could do on month basis. If you need any help just contact me with your data I may be able to find a formula for you.

    Nilesh
Sign In or Register to comment.