Hi Everyone, I know it's possible to add a date to a header or a footer by
using &[Date], however when the next user opens the file, it puts in
today's date (the date that the file was opened). I would like to know if
it's possible to use a command to add in a static date in the header/footer
instead of manually typing it in. I have a macro to format the spreadsheet
the way I want it, and this is my only problem right now.

Thanks in advance for any help.