Saturday, August 31, 2013

How to get current date and time in your excel sheet?


To get current date

Step: Use function =TODAY()

To get current date and time

Step: Use function =NOW()
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Preface 2nd Edition

The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS ...

  • About #N/A Error
    This error indicates that a value is not available to a function or formula. Symptom Excel displays #N/A in one or more cells on a workshee...
  • Use of Advance Filter in MS Excel
    Advance filter available in "Data" ribbon is used to filter your data with some complex criteria. To use advance filter option you...
  • How to move texts from Notepad to Column in MS Excel?
    This is also known as "Import a Delimited Text File". Step 1: To import a Delimited Text File, the user has to go to the “DATA” ri...