Vacation
 

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

"JulieD" wrote:

Hi Paul

this will happen if you've used a function (=NOW() or =TODAY()) to populate
a cell with the date. Rather than doing this just type the date (ctrl &
semi-colon (;)) is the shortcut key for doing this.

Hope this helps
Cheers
JulieD

"Paul" wrote in message
...
Does anyone know how to make the date static in Excel 2000?

Every time the spreadsheet is opened my date field changes to the current
date.

Thanks

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

"jopla" wrote in message
...
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

"JulieD" wrote:

Hi Paul

this will happen if you've used a function (=NOW() or =TODAY()) to
populate
a cell with the date. Rather than doing this just type the date (ctrl &
semi-colon (;)) is the shortcut key for doing this.

Hope this helps
Cheers
JulieD

"Paul" wrote in message
...
Does anyone know how to make the date static in Excel 2000?

Every time the spreadsheet is opened my date field changes to the
current
date.

Thanks