General discussion


Excel program inserting date

By pchlp ·
I created a simple invoice program but I would like to have one cell automatically update with the date on the computer.
I tried this ="mm/dd/yy"-NOW()
but does not work.
Does anyone have a solution for this problem

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by twobordercollies In reply to Excel program inserting d ...

Here is the formula you need:

The Now() formula returns the date and time. The Today() formula returns just the date.

Then you can right click on that cell and select format cells and choose the date format that you want.

Collapse -

by jc2it In reply to Excel program inserting d ...

You can do this manually everytime by using the keyboard shortcut ctrl + ;

To do it automatically you need to use the Today() function.

Read more here:

Related Discussions

Related Forums