Insert Current Date in Worksheet



  • To quickly enter Current Date in your worksheet:
    • Select any empty cell
    • Press CTRL + ; (semicolon)
    • Press Enter.
  • To insert a Date that will update to the current Date each time worksheet is reopened or formula is recalculated:
    • Select any empty cell
    • Type Formula, =TODAY()
    • Press Enter.


No comments:

Post a Comment