Freezing date formula

[bananacitizen]

Hi,
I have excel sheet with formulas in cells that automatically changes with todays date. For example on attached sheet B01 cell G4 I got the formula "=COUNTIF(I13:I100007,TODAY()-1)" I normally send this document to others to view. But this sheets changes automatically. So if someone view the sheet tomorrow he will see different results. My question is how to freeze all formulas activating when I need to send the document out. So if someone open the sheet next month they will view the the same set of results as of today? Any help greatly appreciated

[PaulM100]

Just Copy Paste the today's formulas as values

[kersplash]

In these cases, I have a cell that contains the date you want as the reference date, rather than using TODAY().

[bananacitizen]

Hi Could you please elaborate on that. Just give me an example please.

[Monimonika]

Instead of using TODAY() in your formulas, have them all refer to a single cell (for example, $A$1) that contains "=TODAY()". Then, before you email out a copy of your workbook, you can replace the "=TODAY()" formula in that one cell with a date instead, so all the other formulas in your workbook will be using that date.

So, "=COUNTIF(I13:I100007,TODAY()-1)" would be "=COUNTIF(I13:I100007, $A$1-1)".