excel courses, excel training

advance excel courses

Now formula

The now formula gives the exact time and date that correspond to your computers register. So every time you press F9, the clock will move on if your computers time has moved on.

This formula is just =now(). It takes no other arguments.

The formula gives you the time as well.

See the today formula to get only the date

 

Things you can do with the now formula

  • Use a macro to copy and paste value the date to know when you saved the document...contact us for more info
  • When you print you will see when you printed the document...contact us for more info
  • Use the now formula to make every invoice a unique number...contact us for more info

 

<-----Back to index

Next topic----->

 

 

 

 

 

Home | Testimonials | Terms & Conditions | Contact Us | Courses | Manuals | Sitemap | Articles |