correct date problem

[tincan85]

I am using a spreadsheet using the formula =date(). The problem is the date is not advancing automatically. It has just started doing this and I have been using the sheet for 2 years on the same computer without a problem. The date on the computer is correct. Where is the date being pulled from and how can I get it to display the correct date?

 

[PaddyD]

do you mean:

=today()

??? the date() function requiresd further arguments, viz. date(year,month,day).

anyway - check tools | options | calculation - should be set to automatic.

 

[tincan85]

yes sorry it is =today() I will check the settings