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

now function

ResolvedVersion 2007

Judith has attended:
Excel Intermediate course

Now function

When would this be most useful

RE: Now function

Hi Judith

Thank you for your question and welcome to the forum.

The =NOW() function itself provides the current date and time, when the cell it is entered into is formatted correctly.

You may or may not find it useful depending on what you are using Excel to do, but for example it could be used as part of a longer formula to figure out the number of hours and minutes that had passed/lapsed between two different times entered into a spreadsheet.

Kind regards
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

Excel tip:

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.