I created a master document to use each week to input jobs employees have completed. I am using:

=TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>4,11,4)

to display the upcoming Friday's date in a cell. However if I open up this saved document 3 weeks later to print it, it changes the date.

What can be done to keep it from changing once the date actually gets here.