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]

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
J

 

[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]

Force of habit, you don't have to.

 

[Stephen]

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