Question Regarding the "=Today()" Formula

B_2

Board Regular
Joined
Aug 24, 2002
Messages
210
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
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
 

inarbeth

Well-known Member
Joined
Apr 8, 2002
Messages
912
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.
 

B_2

Board Regular
Joined
Aug 24, 2002
Messages
210
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
 

B_2

Board Regular
Joined
Aug 24, 2002
Messages
210

ADVERTISEMENT

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?
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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)
 

B_2

Board Regular
Joined
Aug 24, 2002
Messages
210

ADVERTISEMENT

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)

Hello Aladin

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?
 

kskinne

Well-known Member
Joined
Feb 17, 2002
Messages
1,267
Office Version
  1. 365
Platform
  1. Windows
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
 

B_2

Board Regular
Joined
Aug 24, 2002
Messages
210
Hi kevin

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

inarbeth

Well-known Member
Joined
Apr 8, 2002
Messages
912
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,221
Messages
5,594,898
Members
413,950
Latest member
solve22

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?

Disable AdBlock

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
Top