How do I add to one cell and auto subtract from another in Excel?
 

I want to track vacation days: taken and left to take. How do I link two
cells so when I add to one the other automatically subtracts the same value?

How do I add to one cell and auto subtract from another in Excel?
 

"Al" wrote in message
...
I want to track vacation days: taken and left to take. How do I link two
cells so when I add to one the other automatically subtracts the same
value?

Let's say you start with 25 days leave available and you want to put the
number of days taken into A1. In the cell where you want the number of days
remaining put the formula
=25-A1

How do I add to one cell and auto subtract from another in Excel
 

Here's what I would do:

In say A1, have total available days.

In say B1, have days taken.

In say C1 put =SUM(A1-B1), this will give number of days left to take or
display a negative number if the person has taken more than allowed from
A1.

HTH