+ Reply to Thread
Results 1 to 2 of 2

Excel 2003 formula - modify one cell, another cell track the modify date

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    New Yow, NY
    MS-Off Ver
    2003
    Posts
    0

    Excel 2003 formula - modify one cell, another cell track the modify date

    I have Microsoft excel 2003, I am looking for a formula that can help tracking daily tasks.
    Column A date, column B text (task description).
    If I modify cell B1, cell A1 automatically change to today's date (the modify date).
    Is there such simple formula without getting into the codes sheet?

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello baby0596cw,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to: Modify formula if certain cell is blank
    By JPWRana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2013, 08:53 PM
  2. Replies: 8
    Last Post: 05-14-2013, 12:36 AM
  3. modify date time cell to an excel format date time
    By rileyp in forum Excel General
    Replies: 12
    Last Post: 03-24-2013, 08:39 PM
  4. Modify a cell with a formula
    By DECROMAX in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-15-2010, 06:11 PM
  5. cell contains formula cannot modify
    By DRLski in forum Excel General
    Replies: 5
    Last Post: 09-20-2006, 12:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1