Excel Tips 21 - Automatically Display the Current Date in Excel
3:05
Added: 2 years ago
From: ExcelisHell
Views: 8,138
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (4)

Sign In or Sign Up now to post a comment!

  • How can I enter only the year? I tried =YEAR(TODAY()) and it gave me 03 July, 1905!!

    90kapo 2 months ago

  • Hi what about using ctrl semi-colon or ctrl+shift semi-colon.

    Ktumba321 1 year ago

  • @Ktumba321 That's a very good shortcut! Thanks for sharing it.

    ExcelisHell 1 year ago

  • Thank you- this is very helpful

    sujit58 1 year ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more