Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 04, 09:45 PM
RobertSP
 
Posts: n/a
Default Automatic date change when spreadsheet changes


I am trying to write an "if" statement that says when the sum of a row
of numbers changes then insert the current day and time. Can someone
help?


--
RobertSP
------------------------------------------------------------------------
RobertSP's Profile: http://www.excelforum.com/member.php...o&userid=15954
View this thread: http://www.excelforum.com/showthread...hreadid=274330


  #2   Report Post  
Old November 1st 04, 10:07 PM
mzehr
 
Posts: n/a
Default

Hi Robert,
See:
http://j-walk.com/ss/excel/files/timesht.htm
http://www.mcgimpsey.com/excel/timestamp.html


"RobertSP" wrote:


I am trying to write an "if" statement that says when the sum of a row
of numbers changes then insert the current day and time. Can someone
help?


--
RobertSP
------------------------------------------------------------------------
RobertSP's Profile: http://www.excelforum.com/member.php...o&userid=15954
View this thread: http://www.excelforum.com/showthread...hreadid=274330




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off automatic date formatting? Nick Turner Excel Discussion (Misc queries) 3 July 13th 06 08:13 AM
Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et wintersunshine Excel Discussion (Misc queries) 7 July 5th 05 09:44 PM
how do i make a date change automatically if i change one before . dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 10:21 PM
Is there an automatic way to change numbers such as 12312001 t curtev Excel Discussion (Misc queries) 1 December 29th 04 11:32 PM
How do I set date to change automatically on invoices created wit. Angel New Users to Excel 3 November 30th 04 05:10 AM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017