Joined: 25 Sep 2007
|Posted: Wed Nov 30, 2016 8:47 pm Post subject: Current date and time - Use of NOW() function in Excel
|To get the current date and time, use the NOW function.
However, to get the current date only use the TODAY() function.
To get the current time only use =NOW()-TODAY(). However, you have to change cell format to Time from category.
However, you can also use these keybord shortcuts to enter current date and time into your cell:
Enter the current date Ctrl+Shift+semi-colon (; )
Enter the current time Ctrl+Shift+colon (: )
Further use (just copy and paste into your excell file to test),
You can also use the NOW() function to get your any targeted date and time.
Returns the date and time 12 hours ago (-0.5 days ago)
Returns the date and time 6 hours ago (-0.25 days ago)
Returns the date and time 2 days ago (-2.0 days ago)
Returns the date and time 2 days and 6 hours ago (-2.25 days ago)
Returns the date and time 2 days and 12 hours ago (-2.5 days ago)
Returns the date and time 5 days in the future(+5 days)
You may also consult Microsoft page here
Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.
For comments of suggestions, please contact us: email@example.com