# Excel - counting days

Options
Registered Posts: 711 Epic contributor 🐘
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

• Registered Posts: 22 New contributor 🐸
Options
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
• Registered Posts: 1,657 Beyond epic contributor 🧙‍♂️
Options
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])
• Registered Posts: 711 Epic contributor 🐘
Options
Thank you both for your help
• Registered Posts: 91 Regular contributor ⭐
Options
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
Privacy Policy