Try using a formula: "=now()"
>
> Date: Sun, 20 Jan 2002 21:43:47 -0000
> From: Mick Fitzpatrick <[log in to unmask]>
> Subject: Auto date update in Excel 97
>
> Hello
>
> Is it possible for the date in an Excel spreadsheet to be automatically
> updated on a daily basis ... without any input from the me?
>
> I use Excel for an Invoice and if it could auto update the date daily it
> would save me a few seconds typing :-)
>
> TIA ... Mick
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|