PC Review


Reply
Thread Tools Rate Thread

Automatically add date into a cell

 
 
=?Utf-8?B?VG9tbW8=?=
Guest
Posts: n/a
 
      14th Jul 2006
I am trying to get cell D2 on sheet 1 to automatically add date and time when
a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
I am using Excel 2002

Can anyone please help
Frustrated Mike
 
Reply With Quote
 
 
 
 
Ashish
Guest
Posts: n/a
 
      14th Jul 2006
Hi,

Answer is

=IF(COUNTA(Sheet2!C8:I59)<>0,NOW(),"")

Paste this formula in column D2

Thanks
Ashish

Tommo wrote:
> I am trying to get cell D2 on sheet 1 to automatically add date and time when
> a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
> I am using Excel 2002
>
> Can anyone please help
> Frustrated Mike


 
Reply With Quote
 
=?Utf-8?B?VG9tbW8=?=
Guest
Posts: n/a
 
      14th Jul 2006
Ashish
thanks heaps, worked like a charm

Satisfied Mike Tommo

"Ashish" wrote:

> Hi,
>
> Answer is
>
> =IF(COUNTA(Sheet2!C8:I59)<>0,NOW(),"")
>
> Paste this formula in column D2
>
> Thanks
> Ashish
>
> Tommo wrote:
> > I am trying to get cell D2 on sheet 1 to automatically add date and time when
> > a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
> > I am using Excel 2002
> >
> > Can anyone please help
> > Frustrated Mike

>
>

 
Reply With Quote
 
=?Utf-8?B?VG9tbW8=?=
Guest
Posts: n/a
 
      14th Jul 2006
Ashish
works great, noticed one thing though, if I insert a number in a cell not in
the range of the IF statement (C8:I59) on sheet 2 the date and time still
changes on sheet 1.

any sugestions why its doing this

Thanks in Advance
Mike


"Ashish" wrote:

> Hi,
>
> Answer is
>
> =IF(COUNTA(Sheet2!C8:I59)<>0,NOW(),"")
>
> Paste this formula in column D2
>
> Thanks
> Ashish
>
> Tommo wrote:
> > I am trying to get cell D2 on sheet 1 to automatically add date and time when
> > a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
> > I am using Excel 2002
> >
> > Can anyone please help
> > Frustrated Mike

>
>

 
Reply With Quote
 
MartinW
Guest
Posts: n/a
 
      14th Jul 2006
Hi Tommo,

That's because the NOW() function is volatile so it will update
everytime you enter anything on the sheet.

Have a look at this site for info on time stamps

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

HTH
Martin


 
Reply With Quote
 
=?Utf-8?B?dHZlYWw=?=
Guest
Posts: n/a
 
      14th Jul 2006
Ashish I am entering dates using the today formula however for a request and
time request made then I am entering the date assigned using today formula;
however at there are times the time assigned will overlap into the next day.
How do I formulate the time requested/assigned to recognize the current date.
the information may not be entered in real time but at the end of a shift
from a paper format. What I am trying to do is make sure the data entry
department enters the date for entry.
--
tveal


"Tommo" wrote:

> Ashish
> works great, noticed one thing though, if I insert a number in a cell not in
> the range of the IF statement (C8:I59) on sheet 2 the date and time still
> changes on sheet 1.
>
> any sugestions why its doing this
>
> Thanks in Advance
> Mike
>
>
> "Ashish" wrote:
>
> > Hi,
> >
> > Answer is
> >
> > =IF(COUNTA(Sheet2!C8:I59)<>0,NOW(),"")
> >
> > Paste this formula in column D2
> >
> > Thanks
> > Ashish
> >
> > Tommo wrote:
> > > I am trying to get cell D2 on sheet 1 to automatically add date and time when
> > > a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
> > > I am using Excel 2002
> > >
> > > Can anyone please help
> > > Frustrated Mike

> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 make 1 date cell automatically change another date cell Scotty Microsoft Excel Worksheet Functions 3 22nd Apr 2010 06:15 AM
Automatically change cell colors based on date in cell Greg Microsoft Excel Misc 1 27th Jan 2009 05:53 PM
Automatically update a cell with a date based on anther cells date GPR GUY Microsoft Excel Misc 2 3rd Nov 2008 03:57 PM
automatically date a cell when entering data in adjoining cell =?Utf-8?B?Sm9obiBJbW0=?= Microsoft Excel Programming 1 9th Oct 2006 02:53 PM
Automatically date cell in Excel =?Utf-8?B?QkdT?= Microsoft Excel Worksheet Functions 2 2nd Sep 2005 05:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:00 AM.