To add a datestamp to a cell in Excel when the value in another cell changes, you can use the following formula:
=IF(A2<>A2, "", TODAY())
This formula will return a blank value if the value in cell A2 has not changed, and will return the current date if the value in cell A2 has changed. You can then copy and paste this formula into the other cells in column B to apply the same logic to those cells.
Here's an example of how you could use this formula:
In cell B2, enter the formula =IF(A2<>A2, "", TODAY()). This formula will return a blank value if the value in cell A2 has not changed, and will return the current date if the value in cell A2 has changed.
In cell B3, enter the formula =IF(A3<>A3, "", TODAY()). This formula will return a blank value if the value in cell A3 has not changed, and will return the current date if the value in cell A3 has changed.
Repeat this process for the other cells in column B as needed.
Good luck!