In Cell A1 I want to write a name, then Excel shall write the date for today in cell B1. I know how to do that. The problem is that the formula I use in cell B1 is:
This formula will today write 28/2-08 but tomorrow the cell will change to 29/2-08 without changing the name in cell A1. How can make it so that cell B1 don't change tomorrow. Meaning how to make the date in cell B1 to be constant or fixed or what to call it.
Thank you in advarce for the help.