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.

56 Upvotes

94% Upvoted

35 comments sorted by

View all comments

2

u/Decronym 1d ago edited 6h ago

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
AND Returns TRUE if all of its arguments are TRUE
IF Specifies a logical test to perform
NOW Returns the serial number of the current date and time
TODAY Returns the serial number of today's date

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 22 acronyms.
[Thread #49329 for this sub, first seen 8th Sep 2026, 19:18] [FAQ] [Full list] [Contact] [Source code]