Now()

[picktr]

What do I use instead of NOW() to
take off the time-stamp. I want the
date to change, like NOW(), I just
don't want the time stamp with it.

Thanks

To

 

[Robert]

You can still use the Now() function, but change the
format of the cell. To do this:

1. Click on the cell
2. Format Menu -> Cells
3. On the Number tab, select Date in the Category list
4. Select the desired format in the Type list

-Robert

 

[Peo Sjoblom]

Or use today

=TODAY()

 

[picktr]

Thanks!

 

[Guest]

Hi

You can also use = TODAY()

Paddy