To enter a date that remains current, use the TODAY.
- Choose Insert | Function.
- In the dialog box, open the drop-down menu near the top and select Date & Time. The Select A Function box shows 14 functions related to date and time.
- Choose the TODAY function to insert the current date and keep it current.