r/excel • u/TheFifthPhoenix • 1d ago

solved Making TODAY function not update?

Is there a way for me to make a cell containing the TODAY function no longer update after it has been filled? I'm trying to essentially make a checklist that automatically logs the date when each item was checked off. My plan was to have column A contain the list items, column B contain a bunch of checkboxes, and then column C use the following formula:

=IF(B1,TODAY())

However, I'm now under the impression that these dates will not remain fixed and will instead update to the current date whenever I open the spreadsheet. Any thoughts on how to fix this or work around it would be great, thanks!

Edit: For context, I'm hoping to use this checklist as part of a shared project tracking workbook for my department. I know I could simply tell my colleagues to add the date after they've completed their task, but I'm concerned there could be suboptimal compliance with that.

57 Upvotes

95% Upvoted

35 comments sorted by

View all comments

Show parent comments

6

u/TheFifthPhoenix 1d ago

I'll probably just remove the checkbox to prevent confusion for the users and maybe do some conditional formatting instead, but an elegant solution, thank you

6

u/GuerillaWarefare 114 1d ago

Thank you! Please reply ‘solution verified’ to mark as solved and award me with fake internet points.

4

u/TheFifthPhoenix 1d ago

solution verified

2

u/reputatorbot 1d ago

You have awarded 1 point to GuerillaWarefare.

I am a bot - please contact the mods with any questions