Excel counting days
 

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'.?

Excel counting days
 

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'.?

Excel counting days
 

I should have mentioned that Excel will try and be helpful and format this as
a date so reformat as general.

Mike

"Mike H" wrote:

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'.?

Excel counting days
 

.... 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'.?

Excel counting days
 

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'.?

Excel counting days
 

Thanks Mike and to all,
Formula worked well and has solved the problem. i had tried to format the
whole collumn for this formula but the empty fields then posted valies of '1'
which affected the tally cell tjhat I set up at the bottom. i'vre solved this
by dragging the formula down each time I add a new client to the list.
Thanks again. A big help.

"Mike H" wrote:

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'.?

Excel counting days
 

Thanks David,
I tried both methods and have gone with the DATEDIF
formula. But your reply was greatly appreciated and the problem has now been
solved.
Grant


"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'.?