Calculating with dates
 

I have a question regarding days and substracting days as a date.

This is my excel sheet

personal Day Day Day Remaining
days Taken Taken Taken Days

3 05/07/07 06/05/07 1


Is there a way with a formula to calculate the remaining days without
entering another column with a number ?

I hope this is understandable.

Thanks

Henk

Calculating with dates
 

try:
=a2-counta(b2:d2:)
so, days less the count of days taken (I'm assuming this is what you meant
to do?)

"Henk" wrote:

I have a question regarding days and substracting days as a date.

This is my excel sheet

personal Day Day Day Remaining
days Taken Taken Taken Days

3 05/07/07 06/05/07 1


Is there a way with a formula to calculate the remaining days without
entering another column with a number ?

I hope this is understandable.

Thanks

Henk

Calculating with dates
 

=A2-(C2-B2+1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Henk" wrote in message
...
I have a question regarding days and substracting days as a date.

This is my excel sheet

personal Day Day Day Remaining
days Taken Taken Taken Days

3 05/07/07 06/05/07 1


Is there a way with a formula to calculate the remaining days without
entering another column with a number ?

I hope this is understandable.

Thanks

Henk

Calculating with dates
 

Yes it worked

Thanks for your help

Henk

"Lisa" wrote:

try:
=a2-counta(b2:d2:)
so, days less the count of days taken (I'm assuming this is what you meant
to do?)

"Henk" wrote:

I have a question regarding days and substracting days as a date.

This is my excel sheet

personal Day Day Day Remaining
days Taken Taken Taken Days

3 05/07/07 06/05/07 1


Is there a way with a formula to calculate the remaining days without
entering another column with a number ?

I hope this is understandable.

Thanks

Henk