Hi, After deciding that this was impossible, an idea came to me while I was in the shower. See the attached. B2 and B3 have data, so C2 and C3 should show the data entry date of 16 March 2011, no matter when the file is viewed. If you enter data into B4, the current date should appear in C4, and should not change from then on. I have only tested this in XL2003. There are limitations and a couple of tricks. Limitations: In your original post, you talk about 'updating' the data in Col A. In this worksheet, the date will only change if the cell in Col A originally has no data. ie, if A5 is blank, and you enter some data there, B5 will show the current date. But if A5 already has data, and you just over-write it with different data, B5 will remain unchanged. To actually change the date, the data in the Col A cell must be deleted, then new data entered. Tricks: In the Tools / Options Menu, Calculation Tab, I've ticked 'Iteration' and changed the Maximum iterations to 1. Also, Col B contains Conditional formatting to hide the erroneous dates of cells that don't have adjacent data in Col A. Not sure if this any use to you, but it was an interesting exercise. Regards - Dave. On Sun, Mar 13, 2011 at 1:53 AM, Hems <coolh...@gmail.com> wrote:
Dear All,
I want today's date in next column (column B) on the day when first column (
column A) was updated.
for Ex. if A3 was updated on 14th Mar'11 then B3 should display that date. If i
open this file on 16th Mar'11 then also B3 should display 14th Mar'11 and not
16th Mar'11.
Appreciate i get formula for this issue rather then macro.
Thanks in advance
Kind Regards,
Hemant
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Book1.xls
Description: MS-Excel spreadsheet
