HiOn 2002-10-07 04:28, B_2 wrote:
Hi People
Cell A39 contains the '=TODAY()' formula, is it possible to enter dates manually into this Cell without loosing the Formula.
As sometimes i need to backtrack the date..by a few days
thx
On 2002-10-07 15:59, B_2 wrote:
Its ok now using the cell below
A39 =TODAY()-$A$40
Thanks for the tip, but is there a way to hide the number i enter into CELL A40 when i print my document?
On 2002-10-07 16:06, Aladin Akyurek wrote:
On 2002-10-07 15:59, B_2 wrote:
Its ok now using the cell below
A39 =TODAY()-$A$40
Thanks for the tip, but is there a way to hide the number i enter into CELL A40 when i print my document?
You can whiten the font of the cell using conditional formatting. The formula to use is:
=LEN($A$40)
On 2002-10-07 16:06, Aladin Akyurek wrote:
On 2002-10-07 15:59, B_2 wrote:
Its ok now using the cell below
A39 =TODAY()-$A$40
Thanks for the tip, but is there a way to hide the number i enter into CELL A40 when i print my document?
You can whiten the font of the cell using conditional formatting. The formula to use is:
=LEN($A$40)