Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

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

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 268

PostPosted: Wed Nov 30, 2016 8:47 pm    Post subject: Current date and time - Use of NOW() function in Excel Reply with quote

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

=NOW()






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.

=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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group