Chartman of the Bored
Board Regular
- Joined
- Apr 24, 2002
- Messages
- 83
I have a forumula that calculates the Friday of the current week:
=TODAY()-WEEKDAY(TODAY())+6
I'd like to "freeze" the date when someone saves the workbook.
I know this topic has been addressed before. For example:
http://www.mrexcel.com/board/viewtopic.php?topic=14767&forum=2
But I don't want to use a checkbox, as suggested by Tom. And I don't follow Juan Pablo's code, though I do know a bit of VBA (not enough, though).
Thanks in advance for any suggestions.
=TODAY()-WEEKDAY(TODAY())+6
I'd like to "freeze" the date when someone saves the workbook.
I know this topic has been addressed before. For example:
http://www.mrexcel.com/board/viewtopic.php?topic=14767&forum=2
But I don't want to use a checkbox, as suggested by Tom. And I don't follow Juan Pablo's code, though I do know a bit of VBA (not enough, though).
Thanks in advance for any suggestions.