Software

Ask something
Discussion Locked

Excel program inserting date

0 helpful
2 replies

by pchlp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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
THanks

2 replies

by twobordercollies

Here is the formula you need:
=TODAY()

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.

This discussion is closed to new replies.