how to display deferent value of Now() if cell contains text

**eugz** · 07-12-2023, 07:42 PM

Hi All

In the attached spreadsheet, I would like to get the value of the Now() function in each cell of the row in column C depending on when the cell in column B gets the text value "Complete". In that case each cell in column C will have different values. How it to do?
CurrentDate.xlsx

**wk9128** · 07-12-2023, 08:23 PM

pls try this code

Please Login or Register  to view this content.

**eugz** · 07-14-2023, 09:08 AM

Hi wk9128. Thanks for reply.
You code works fine. But I have a procedure that makes a copy of the worksheet. In this case, when I run it, your code doesn't work on the copied worksheet. Can the code be modified to allow functions to be executed on the copied worksheet?

Thanks

**wk9128** · 07-14-2023, 09:27 AM

Originally Posted by eugz

Hi wk9128. Thanks for reply.
You code works fine. But I have a procedure that makes a copy of the worksheet. In this case, when I run it, your code doesn't work on the copied worksheet. Can the code be modified to allow functions to be executed on the copied worksheet?

Thanks

PLS TRY THIS CODE

Please Login or Register  to view this content.

**Glenn Kennedy** · 07-14-2023, 10:30 AM

1. Go to: Options/Formulas and check Enable Iterative Calculations.

2. In C1, copied down:
=IF(B1="","",IF(C1="",NOW(),C1))

When "Complete" is selected in column B a non-updating date stamp is added in column C.