individual cell date modified will be marked in another cell

[CL1000]

I have a spreadsheet on Onedrive for me and my employees to keep track of our machine hrs for maintenance. I use Excel 2013 Pro to set it up.

I need to be able to have the date that one cell is modified be enter in another cell to the right of that one.

Say I have column "D",with the machine hrs and column "E" has the date column "D" was modified. I need to have column "E" update automatically when ever a cell in column "D" is modified.

Example: say D5 is modified to 5,567hrs and E5 will automatically log down (todays date) 07/20/2019. D4 was not modified so E4 stills show 07/13/2019 (last date it was modified).

I have tried this formula in cell E5 =IF(D5="",THEN,TODAY()) However when I open the page the next day all cells in column E shows the current days date and not the day it was modified.

Thanks,

CL1000

 

[DanteAmor]

OK, Thanks, sounds easy enough

Your welcome, thanks for the feedback.