Vacation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Julie,
Hope you can help with a vacation spreadsheet I am using. On an anniversary
date, my employees get all vacation appropriate to their longevity added to
their tracking cell (the cell where the total is kept). Is there a formula
that, on a certain calendar date, I can - say the number 15 - to a particular
cell?
Thanks
John
 
John,

You could use a variant of a formula like this, for someone whose
anniversary date is Dec 1 (you may need to interchange day and month,
depending on your date system):

=DATEDIF("12/1/2000",NOW(),"y")*15

You can always write the function to use cells to enter the dates and nubmer
of days:
=DATEDIF(A1,A2,"y")*A3

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Vacation Tracker 5
Vacation Accrual formula 1
formula in Excel 4
Excel Formula 3
Excel Formula 15
formula Help 2
Function to figure vacation accrual 5
Auto populating and assigning numeric value to a number 7

Back
Top