Static date?

[Paul]

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

 

[JulieD]

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

 

[gatwickxx]

Alternatively copy the cell with =NOW() and do Edit, Paste Special,
Values and the formula will go

 

[jopla]

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

 

[Bernie Deitrick]

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