Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to insert current day or month or year into cell in Excel?

When you want to quickly insert the current month or current date in Excel, how can you insert? The following method will help you quickly insert current month or date into a cell, or into header/footer of worksheet.

Insert current year, month or date by formulas and hotkeys

Insert current year, month or date with special date formatting

Insert current date and time in cell/header/footer

Double click to insert the day/weekday/month/year of current date into active cell

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial


arrow blue right bubble Insert current year, month or date by formulas and hotkeys in Excel


In Excel, you can insert current year, month, date, and timestamp with formulas easily.

Take inserting current month for example, please type the formula =MONTH(TODAY()) in the cell you want to insert current month and press Enter.

  Formula  Formula returns
Insert Current Month =MONTH(TODAY()) 8
Insert Current Month =TEXT(TODAY(),"MMMM") August
Insert Current Year =YEAR(TODAY()) 2015
Insert Current Date =TODAY() 2015/8/20
Insert Current date and time =NOW() 2015/8/20 9:41

Hotkeys can also help you insert current date and time easily:

(1) Press CTRL+ ; keys to insert current date.

(2) Press CTRL+ ; to insert the current date first and release the keys, then press Space button to insert a space, at last press CTRL+SHIFT+; to insert the current time.

note ribbon Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more…     Free trial

arrow blue right bubble Insert current year, month or date with special date formatting

If you have Kutools for Excel installed, its Insert Date utility can help you quickly insert current month or date with various date formatting with just several clicks in Excel.

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

After installing Kutools for Excel, please do as following steps:

1. Select a cell that you want to insert current year, month or day, and click the Kutools > Insert > Insert Date, see screenshot:

2. In the Insert Date dialog, check the Using format option, and then double click a date formatting in the right pane. See screenshot above:

Now current date is inserted into active cell with the specified date formatting.

Note: By default current date is selected in the calendar in the Insert Date dialog box. If you need to insert other date, you need to select the date in the calendar firstly.

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


arrow blue right bubble Insert Current date and time in cell/header/footer with Kutools for Excel

If you have Kutools for Excel installed, its Insert Workbook Information utility enables you to insert current date and time into cell/header/footer easily. Please do as follows:

Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel

1. Click the Workbook > Insert Workbook Information.

2. In the opening Insert Workbook Information dialog box, check the Current date and time option, in the Insert at section specify a position, and click the Ok button. See screenshot above:

Then current date and time is inserted at the specified cell, header, or footer at once.

Kutools for Excel - Includes more than 300 handy Excel tools. Full feature free trial 60-day, no credit card required! Get it now!


arrow blue right bubbleDemo: insert current day, month, or year into cell/header/footer in Excel

In this Video, the Kutools tab and the Kutools Plus tab are added by Kutools for Excel. If need it, please click here to have a 60-day free trial without limitation!


arrow blue right bubbleRelative article:

Quickly insert current date with specific date format


Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Larry Kiser · 8 months ago
    In EXCEL 365, I want to insert the month based on cell A2 along with a text string in the header.
    • To post as a guest, your comment is unpublished.
      kellytte · 5 months ago
      Hi Larry,
      Do you want to extract the month name from Cell A2 which is filled with date and text string? Or extract month name from Cell A2 and output the month nae and text string together?
  • To post as a guest, your comment is unpublished.
    Larry Kiser · 8 months ago
    I want to insert the month based on cell A2 along with a text string.
  • To post as a guest, your comment is unpublished.
    Nina · 1 years ago
    =TEXT(MONTH(TODAY()),"mmmm") gives me January, although it is now February. What is wrong with this formula?
    • To post as a guest, your comment is unpublished.
      Julia · 1 years ago
      Take MONTH out of the formula:
      =TEXT(TODAY(),"MMMM")
  • To post as a guest, your comment is unpublished.
    nu · 1 years ago
    how to get current month only in header/footer
    • To post as a guest, your comment is unpublished.
      kelly001 · 1 years ago
      No normal ways can get current month in header or footer in Excel. But VBA can:

      Sub add_date_header()
      ActiveSheet.PageSetup.CenterHeader = Format(Date, "mmmm")
      End Sub
  • To post as a guest, your comment is unpublished.
    riz · 1 years ago
    Hi all, I need a formula to COUNT all the records from previous months and years from a single column source. Can someone please help me for this?
    For Example, I have dates in A column, but I want to get the COUNT not sum, of the only dates which are from previous month or year.
    • To post as a guest, your comment is unpublished.
      Tang Kelly · 1 years ago
      Hi,
      The topic of this article is about inserting the current date, month, or year.