no date refresh

  • Thread starter Thread starter RichardO
  • Start date Start date
R

RichardO

Hello all:

I have a summary sheet that summarizes today's info and also has th
summary of 4 prior days info (these values have been pasted as value s
they don't have a data behind them). Part of the summary include
counting the number of the workdays.

In order to be able to use my formula in the summary sheet, I copy th
column that has the formulas and insert copied cells, so that th
formulas are available. And then I copy an paste value on the ol
column, so that when I put in my new data in the other worksheets, th
old column numbers will not change.

However, I am having a problem with the date formula above, becaus
when I open the workbook, it automatically, calculates the differenc
between the date in b2 of one of the worksheet and today's dat
(=networkdays(b2,today()). So, the count in the "OLD" column i.e
yesterday's info is no longer correct. So, today the count might be 2
if I open the worksheet today, the count might be 1 instead.

I guess all I am trying to say is that, how do I prevent this fro
happening? I can't copy and paste value on the today's summary colum
before closing the workbook for use tomorrow because I need the formul
when I use the workbook the following day.

Thanks a lot for your help.


Richard
 
How about putting the formula in some other cell somewhere, but leaving off
the "=" so that it's just text and not a formula. Then, it'll always be
available for copy paste, and all you have to do to convert it back to a
formula is put the = back. This way, you can do your copy paste special
value before the end of each day....
 
Back
Top