I have a checkbox that when checked, places "Paid" and the date in a cell.
IF(V12,"PAID "&TEXT(TODAY(),"mmmm dd")
Once the checkbox is checked, I'd like the date value that it places in the cell to remain static. In otherwords do not change as the date changes. Only if I uncheck the cell, and then recheck the cell would the current date be returned.
Any ideas?
ep
Bookmarks