I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

You can use a shortcut key of ctrl-semicolon (ctrl-;) to enter the static time.

Or you can use a macro to plop in the date/time.

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

J.P. wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

--

Dave Peterson

This question is so similar to the one that I have....

how could I accomplish this..=IF(F8="Complete",TODAY(),"")

BUT with any text (not a specific word like 'Complete') and in the situation
where any change in a row (a few columns with text and a date column) will
automatically update the date.

Thanks
June


"Dave Peterson" wrote:

You can use a shortcut key of ctrl-semicolon (ctrl-;) to enter the static time.

Or you can use a macro to plop in the date/time.

J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

J.P. wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

--

Dave Peterson

Hi June

Maybe
=IF(ISTEXT(F8),TODAY(),"")

--
Regards

Roger Govier


"June D" wrote in message
...
This question is so similar to the one that I have....

how could I accomplish this..=IF(F8="Complete",TODAY(),"")

BUT with any text (not a specific word like 'Complete') and in the
situation
where any change in a row (a few columns with text and a date column)
will
automatically update the date.

Thanks
June


"Dave Peterson" wrote:

You can use a shortcut key of ctrl-semicolon (ctrl-;) to enter the
static time.

Or you can use a macro to plop in the date/time.

J.E. McGimpsey shows a way to put a time stamp on the same row when
something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

J.P. wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete"
into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho
can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

--

Dave Peterson

Event code.......

Option Compare Text
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo enditall
Application.EnableEvents = False
If Target.Address = "$F$8" Then
If Target.Value = "Complete" Then
Excel.Range("G8").Value = Now
End If
End If
enditall:
Application.EnableEvents = True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste into that module.


Gord Dibben MS Excel MVP

On Fri, 30 Jun 2006 06:36:01 -0700, J.P. wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,

With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

what is the custom format for the date/time format
Wednesday, 17 October 2007, 15:25

"Fred Smith" wrote:

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

Try dddd, dd mmmm yyyy, hh:mm
If you look at the custom formats in the default list, you can then vary the
parameters to suit your requirements.
--
David Biddulph

"Pezacide" wrote in message
...
what is the custom format for the date/time format
Wednesday, 17 October 2007, 15:25

"Fred Smith" wrote:

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into
F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can
I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

The format is

dddd, dd mmmm yyyy, hh:mm

but you can't make it static by formatting


http://www.mcgimpsey.com/excel/timestamp.html




--

Regards,

Peo Sjoblom




"Pezacide" wrote in message
...
what is the custom format for the date/time format
Wednesday, 17 October 2007, 15:25

"Fred Smith" wrote:

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into
F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can
I keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.

Tell us what you tried, and why it didn't do what you want. Then we're better
able to help you.

--
Regards,
Fred


"Pezacide" wrote in message
...
what is the custom format for the date/time format
Wednesday, 17 October 2007, 15:25

"Fred Smith" wrote:

Change Today() to Now(), and custom format the date/time.

--
Regards,
Fred


"pezacide" wrote in message
...
With the formula below how do i change it so it shows date and time?

"J.P." wrote:

I have entered the following formula into my spreadsheet:
=IF(F8="Complete",TODAY(),"")
The formula enters today's date when I enter the word "complete" into F8.
However, tomorrow, the formula will update to tomorrow's date. Ho can I
keep
the date from changing every day after the initial entry?
Thanks,
--
J.P.