date

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date

Date

resolvedResolved · Low Priority · Version 2003

Gemma has attended:
Excel Introduction course

Date

how do i put in todays date

RE: Date

Hello Gemma,

Thank you for your question and welcome to the forum.

The Formula/Function to put in todays date is as follows:

=today()

Thanks and kind regards

Maggie


 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Server loaded in 0.09 secs.