auto input of dates IF/THEN

[FRAC]

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é

 

[dr_shivan]

C5 =if(A5="","",today())
copy down for the rest of the cell

 

[FRAC]

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]

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]

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]

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]

What is the formula that you're entering?

This is the formula I have tried:
(Starting from the first = of course

C5 =if(A5="","",today())
copy down for the rest of the cell

Brgds André

 

[Brian from Maui]

What is the formula that you're entering?

This is the formula I have tried:
(Starting from the first = of course

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]

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]

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.