Current date and time - Use of NOW() function in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 291
Joined: Tue Sep 25, 2007 12:41 pm

Current date and time - Use of NOW() function in Excel

Post by Admin » Wed Nov 30, 2016 8:47 pm

To get the current date and time, use the NOW function.

=NOW()


Image



However, to get the current date only use the TODAY() function.


Image


To get the current time only use =NOW()-TODAY(). However, you have to change cell format to Time from category.


Image



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.

=NOW()-0.5
Returns the date and time 12 hours ago (-0.5 days ago)


=NOW()-0.25
Returns the date and time 6 hours ago (-0.25 days ago)


=NOW()-2.0
Returns the date and time 2 days ago (-2.0 days ago)


=NOW()-2.25
Returns the date and time 2 days and 6 hours ago (-2.25 days ago)


=NOW()-2.5
Returns the date and time 2 days and 12 hours ago (-2.5 days ago)


=NOW()+5
Returns the date and time 5 days in the future(+5 days)


You may also consult Microsoft page here






*Recommended:

Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com

Post Reply