# Question Regarding the "=Today()" Formula

#### B_2

##### Board Regular
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

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
On 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
Hi
Use the same formula to backtrack the date..by a few days, like:

=TODAY()-3 etc.

Eli

You could also refer to another cell containing the number of days back, eg =TODAY()-\$Z\$100. Then simply amend Z100 as necessary or leave it blank to keep to TODAY(). This method avoids your having to edit the cell containing the formula.

thx for the reply guys

inarbeth i have tried your suggestion by typing the following formula

CELL A39 Has the formula =TODAY()-\$B\$39
Instead of using Z100 i am using B39 but it dont work.

Am i doing something wrong or is my formula wrong?

thx
This message was edited by B_2 on 2002-10-07 15:55

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 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)

I tried this but it did not work.
I did the following

FORMAT/CONDITIONAL FORMATTING/CONDITION 1 (FORMULA IS) Typed the formula and then hit OK.

On printing the value showed up?

after you type the formula, you then have to click on the 'format' button, select the 'font' tab, and change select a font color of white before hitting the 'ok' button. do this and your conditional format should work as expected.

HTH
kevin

Hi kevin

Got it, hope your keeping well mate...
thx again guys your knowledge is awesome

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)

You can also use Format, Custom Format ;;; to hide the cell's contents

Replies
7
Views
114
Replies
9
Views
292
Replies
3
Views
269
Replies
0
Views
181
Replies
6
Views
126

1,212,138
Messages
6,106,167
Members
448,002
Latest member
stig20

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back