Help with saving a Final date with logic statement

[arooney88]

I have a workbook that is titled "Results". It has 2 columns that I need help with, a 'status' column (B) and a 'finalized date' column (C)

Column B is the 'status' column: Formula: ('[May Database]Summary'!$B$1)
The May Database B1 column is a dropdown with options "In Progress" and "Final" that will be switched manually.
The results workbook pulls it's status from the May Database workbook.

So I need my results workbook to update it's 'finalized date' column (C) when the May database says "Final" but populate and save the day that the May database was manually switched to 'Final'

My question is would this forumula work?:
Results workbook status column: C1= IF(B1="Final", Now(), "")

Would this save the date when the May Database was manually switched to 'Final' or will this just update my current day everytime I open this workbook since Now() returns current day? Is there a way to save a date when it was finalized and then keep that date?

 

[arooney88]

In a nutshell, I need a way to save a date in a column once a certain criteria is met. when B1="Final" ----> Save the date that happened into column C