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
|