David,

Your absolutely correct and I should have mentioned it but I prefer to
introduce the datedif formula for doing these type of calculations
particularly because it's undocumented. Have MS changed that in E2007 I
wonder.

Mike

"David Biddulph" wrote:

.... or, more simply, =B1-A1+1
You don't need DATEDIF if you are working in days.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

Try this with the earlier date in A1

=DATEDIF(A1,B1,"d")+1

Note that datedif isn't documented in Excel but is well documented here

http://www.cpearson.com/excel/datedif.aspx

Mike

"tmann" wrote:

I would like to know how to get Excel to count the number days between 2
dates inclusive of both dates. it is to count haw many days a client is
on a
health program. I have tried the 'days365' function but this does not
count
the second date and so the count is always one day short.
Am I able to get the function to add 1 day to the 'days 365'.?