Tricks to work with Date and time in EXCEL

To know which month is running, use function

=Month(Today())

To see the month name instead of number, use function

=Text(Month(Today()),”MMMM”)

This shows the month’s name in your excel language

To know which year is running, use function

=Year(Today())

To see the last 2 digits of the year, use function

=Right(Year(today()),2)

To find the day of the week for today, use function

=Weekday(today())

This will give a number from 1 to 7 (1 for sunday, 7 for Saturday)

To see the weekday name instead of number, use function

=Text(today(),”DDDD”)

To see day of today only, use function

=Day(today())

 
Note: In place of Today() you can give any date, to find information of that date.

Be an Expert in MS Excel, VBA Automation….. Enroll for Complete Course Now>>>>>

If you like this trick, then please share it using links below…..

Please follow and like us:
RSS
Follow by Email
Facebook
Google+
http://klick2learnmore.com/tricks-to-work-with-date-and-time-in-excel/
Twitter
YouTube
YouTube
LinkedIn

3 responses to “Tricks to work with Date and time in EXCEL”

  1. Ramkumar says:

    I had been eager to know the tricks about excel

    • klick2learnmore says:

      Thanks Ram.. Please follow our blog and learn new tricks about MS Excel

      Cheers
      klick2learn

    • Cammie says:

      Th&8t#a217;s why I love this site. Thanks for the great analysis Darius. Anyone else notice that when Kobe is out Ron steps up and plays really outstanding ball? It really hits home what a multi- dimensional gifted player the dude still is and how committed he is to this team. He’s content in his role and then steps it up and become a floor leader and offensive threat when called upon.

Leave a Reply

Your email address will not be published. Required fields are marked *