Subtraction formula

[Al]

I am new to Excell and need a simple formula to track Vacation days. If I
have Days taken in cell A1, how do I get cell B1 to show the number of use or
lose days left?

[JASil]

"Al" wrote:

> I am new to Excell and need a simple formula to track Vacation days. If I
> have Days taken in cell A1, how do I get cell B1 to show the number of use or
> lose days left?

[pinmaster]

Hi, say you have 25 days of vacation available, then:

in B1
=25-A1

or

=D1-A1
where D1 has the total number of vacation days available.

HTH
JG

[DNA]

There are a variety of way:

If the norm amount of vacation is say 14 days, then in B1 put:

=SUM(14-A1)

Can you be more specific?

[Sloth]

why do you use the SUM function?

"DNA" wrote:

> There are a variety of way:
>
> If the norm amount of vacation is say 14 days, then in B1 put:
>
> =SUM(14-A1)
>
> Can you be more specific?
>
>

[DNA]

Force of habit, you don't have to.

[Stephen]

"Al" <Al@discussions.microsoft.com> wrote in message
news:DE5AE197-11AC-4732-B703-353135EE34B2@microsoft.com...
>I am new to Excell and need a simple formula to track Vacation days. If I
> have Days taken in cell A1, how do I get cell B1 to show the number of use
> or
> lose days left?

When you have asked a question once, why not read the reply or replies
before posting again? I answered your original question at 14:32, yet you
repost at 15:10. If you need to follow up on replies, please keep to the
same thread.

Stephen