I am looking to insert a date in a Cell when another Cell's number has been changed.
I was using If statement as: If(isnumber(f4),TODAY())
but I don't think it is working properly
the cells columns would be, e.g. "Consumables stock" and "date updated".
So if someone changes a number is the "consumables stock" column, date updated column auto-updates with current date.
How would I go by in doing this?
It can be achieved easily using VBA.
Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Is there a way to do using excel formula/conditional formatting?
DOn't want to use VBA code.
=IF(ISNUMBER(F4),TODAY()) could be ok, why do you think it isn't working ?
Last edited by rollis13; 12-08-2013 at 06:48 PM.
Whenever I open up the file, it auto updates the cell with current date, without any modifcations to anything just as there IS a number, thus adds current date.
Only want to change the date to current date if the cell itself changes.
Supposing your formula is in cell G4 you could use:
=IF(ISNUMBER(F4),IF(G4="",TODAY(),G4),"")
but you will get a Circular Reference Error so then you need to go to Tools > Options > Calculation > check Iterations > Max =1.
Last edited by rollis13; 12-09-2013 at 10:02 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks