My pre-populated date keeps changing to the day I open the file
Greetings everyone.
I got an excel sheet that populates the date when someone selects a drop down of names. This means that person completed a task.
The problem is, when I open the file on another day, the dates change to today.
I just need that date to be the original date when it was originally selected and not change to today unless the name changes.
Thank you in advance for your assistance.
=IF(OR(J5<>””, K5<>””), TODAY(), “”)
Greetings everyone. I got an excel sheet that populates the date when someone selects a drop down of names. This means that person completed a task. The problem is, when I open the file on another day, the dates change to today.I just need that date to be the original date when it was originally selected and not change to today unless the name changes. Thank you in advance for your assistance. =IF(OR(J5<>””, K5<>””), TODAY(), “”) Read More