The following two forumulas are extremely useful.  As simple as they may seem, they can play a vital role in many Excel documents.

 Current date and time

=NOW()

Current Date

=TODAY()

discuss this topic to forum