auto input of dates IF/THEN

FRAC

New Member
Joined
Jan 20, 2005
Messages
7
Hi,

I'm trying to make a formula which makes a date pop up, if a cell has been used..
Example: if text is entered in cell A5, then todays date should show in cell C5. But if there is no text in A5, then cell C5 should appear empty.

Is this possible?
I'm using Excel 2000.

Brgds André
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

FRAC

New Member
Joined
Jan 20, 2005
Messages
7
Thanks for your answer, but when I try this, Excel says I have a formula error..

Any thing I can do about that?


Brgds André
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
FRAC said:
Thanks for your answer, but when I try this, Excel says I have a formula error..

Any thing I can do about that?


Brgds André

What error do you get? Caution on using Today(). The date will change and is not static.
 

FRAC

New Member
Joined
Jan 20, 2005
Messages
7

ADVERTISEMENT

The error message displays as the "standard" excel error in formula.
When I hit 'OK' this part of the formula is highlighted: "","",TODAY

Brgds André
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
FRAC said:
The error message displays as the "standard" excel error in formula.
When I hit 'OK' this part of the formula is highlighted: "","",TODAY

Brgds André

What is the formula that you're entering?
 

FRAC

New Member
Joined
Jan 20, 2005
Messages
7

ADVERTISEMENT

Brian from Maui said:
What is the formula that you're entering?
This is the formula I have tried:
(Starting from the first = of course :biggrin:
dr_shivan said:
C5 =if(A5="","",today())
copy down for the rest of the cell

Brgds André
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
FRAC said:
Brian from Maui said:
What is the formula that you're entering?
This is the formula I have tried:
(Starting from the first = of course :biggrin:
dr_shivan said:
C5 =if(A5="","",today())
copy down for the rest of the cell

Brgds André

What dr_shivan meant was in cell C5 enter,

=IF(A5="","",TODAY())

Again, Today() is not static, when you open the workbook tomorrow, it'll have tomorrow's date and not todays.
 

FRAC

New Member
Joined
Jan 20, 2005
Messages
7
Brian from Maui said:
What dr_shivan meant was in cell C5 enter,

=IF(A5="","",TODAY())

Again, Today() is not static, when you open the workbook tomorrow, it'll have tomorrow's date and not todays.

I still get the same error message.
But when I use =IF(A5>",";TODAY()) I get the result I want, exept cell C5 displays FALSE until text is entered in A5..

Can you help me make the today() static somehow? I would like to keep the date when text was entered in the cells..

Thanks!

Brgds André
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
FRAC said:
Brian from Maui said:
What dr_shivan meant was in cell C5 enter,

=IF(A5="","",TODAY())

Again, Today() is not static, when you open the workbook tomorrow, it'll have tomorrow's date and not todays.

I still get the same error message.
But when I use =IF(A5>",";TODAY()) I get the result I want, exept cell C5 displays FALSE until text is entered in A5..

Can you help me make the today() static somehow? I would like to keep the date when text was entered in the cells..

Thanks!

Brgds André

To make the date static, you'll need some code. do a search of the board for time stamp. There are lots of code on this subject.
 

Forum statistics

Threads
1,147,668
Messages
5,742,514
Members
423,734
Latest member
123hmMission

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