Create a spreadsheet that would insert the current date into a cell or
expression when opened.

For example the cell would be something like...
[The membership roster as of Date()]

and would display "The membership roster as of Jan. 16, 2008"

when opened on Jan. 16, 2008.