Sometimes we need to enter a date automatically when data is entered in Excel. In this article, we are going to show you how to enter date automatically when data is entered in Excel in 5 swift approaches. We have also included some relevant concerns at the end of this article. So let’s get started.
📂 Download Excel File
Download the free workbook from here:
Learn to Automatically Enter Date When Data Is Entered in Excel with 5 Easy Approaches
While writing this article, “How to Enter Date Automatically when Data Entered in Excel”. We’ve considered a dataset that contains approximately 10 columns and 4 rows. In this dataset, we added Product, ID, and Manufacturing Date to make you better understand. But if you want, you can change the entities and put the values of your own.
Using Ctrl+Semicolon One of the easiest ways to enter dates automatically in Excel when data is entered is the application of a keyboard shortcut. You can do this by performing the following steps. ⬇️⬇️ STEPS ⬇️⬇️ Using Ctrl+Shift+Semicolon There is another shortcut for keyboard application in Excel when entering data. We are discussing this below for you. ⬇️⬇️ STEPS ⬇️⬇️ Using Multiple Keyboard Shortcuts There is one more technique of the application of a keyboard shortcut to enter dates automatically when data is entered in Excel. You just need to follow the below steps. ⬇️⬇️ STEPS ⬇️⬇️ There are many functions in Excel to make mathematical calculations easier. In this article, we are going to discuss some functions of Excel to enter date automatically when one enters date. To use the TODAY Function, you need to follow the below steps. ⬇️⬇️ STEPS ⬇️⬇️ =TODAY() Undoubtedly, we can say that using the TODAY Function is one of the easiest ways to enter date automatically in Excel when data is entered. Another function in Excel is the NOW Function to enter the date automatically when data is entered. We are going to discuss it for you below. ⬇️⬇️ STEPS ⬇️⬇️ =NOW() It is for sure that using the NOW Function is very simple to enter a date automatically while entering a date in Excel. There are many Functions in Excel. You can use them whenever you need. In this article, we’ve used IF and NOW Functions together to enter date automatically in Excel when data is entered. Follow the steps given below and you’ll be able to use those functions. ⬇️⬇️ STEPS ⬇️⬇️ =IF(C5<>””,IF(D5=””,NOW(),D5),””) 🔨 Formula Breakdown It is a Timestamp function. It indicates that when C5 is empty, then D5 is empty too. And when we give input in C5, then D5 will get value simultaneously. We can do this by simply applying IF and NOW Functions together. IF is for the condition and NOW will give us time when one enters the date. Surely, using IF and NOW Functions together is one of the simplest ways to enter date automatically when data is entered in Excel. If you intend to enter a date in Excel automatically when data is entered, then utilization of the Autofill option is one of the best approaches for you. There are many choices in the Autofill option. You can maintain the following steps to autofill dates serially by increasing one day. ⬇️⬇️ STEPS ⬇️⬇️ To do this you need to follow the below-mentioned procedures: ⬇️⬇️ STEPS ⬇️⬇️ This is another tactic for entering date automatically in Excel when data is entered. Just follow the below-mentioned steps. ⬇️⬇️ STEPS ⬇️⬇️ If you want to autofill dates with years, you can do this by following the below steps- ⬇️⬇️ STEPS ⬇️⬇️ You can also use the Autofill option to give the input of a series of dates. You just have to maintain the following steps. ⬇️⬇️ STEPS ⬇️⬇️ Undoubtedly, all the options of Autofill are very easy to maneuver and very simple as well as user-friendly. There are many features in Excel to do various types of calculations. The Fill Series option is one of those. If you want to enter date automatically in Excel when data is entered, you can use this option by maintaining the below-mentioned steps. ⬇️⬇️ STEPS ⬇️⬇️ Home >> Editing >> Fill >> Series Home >> Editing >> Fill >> Series Home >> Editing >> Fill >> Series Assuredly, using the fill series feature in Excel is one of the best methods of entering date automatically while entering date. When you intend to enter a date automatically in Excel when data is entered, then using the VBA code is one of the best choices for you. Executing VBA IS not very tough. You just have to maintain the following procedures. ⬇️⬇️ STEPS ⬇️⬇️ VBA Code =MFDate(C5) =MFDate(C6) Finally, you can clearly understand that using VBA code to enter date automatically in Excel when data is entered, is a very user-friendly method. Auto-populating a date in Excel when another cell is updated is one of the major techniques for entering dates automatically. You can easily achieve this technique by maintaining the following steps. ⬇️⬇️ STEPS ⬇️⬇️ VBA Code Assuredly, this is a very simple process to auto-populate the date in Excel when another cell is updated. While entering the date automatically in Excel when data entering data, you need to be aware of the following things- If we summarize the whole article, we basically have tried to show you – how to enter date automatically in Excel when data is entered with some approaches. 📌 Secondly, in Approach 2, we applied various types of Excel Functions here: 1. TODAY Function. 2. NOW Function. 3. IF and NOW Functions 📌 Thirdly, in Approach 3, we’ve used the Autofill Feature of Excel to enter the date automatically when entering data. 📌 Fifthly, in Approach 5, we’ve tried to use VBA code which is a very important process to enter dates automatically in Excel when entering data. Mainly we’ve tried to make you understand different strategies to enter dates automatically in Excel when entering data. We wish that you would be able to enter the date automatically when data entered in Excel using this article. As several methods have been shown here, you can easily follow which one is comfortable for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website www.ExcelDen.com.1. Application of Keyboard Shortcuts to Enter Date Automatically in Excel
2. Using Excel Functions
2.1 Using TODAY Function
2.2 NOW Function
2.3 IF and NOW Functions Combined
3. Utilization of Autofill Option
3.1 Autofill Dates Serially by Increasing One Day
3.2 Autofill Dates of Only Weekdays
3.3 Autofill Dates by Months or Years
3.4 Autofill Dates by 2nd or 3rd or Nth Days
4. Using Fill Series Feature
5. Using VBA Macro
Function MFDate(Cell As Range)
If Cell.Value <> "" Then
MFDate = Format(Now, "dd-mm-yy hh:mm:ss")
Else
MFDate = ""
End If
End Function
How to Auto Populate Date in Excel When Another Cell Is Updated
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("C5:C8"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
📄 Important Notes
<img class="emoji" role="img" draggable="false" src="https://s.w.org/images/core/emoji/14.0.0/svg/1f58a.svg" alt="🖊️" />
You must press the proper keys when you intend to use Keyboard Shortcuts. While using the VBA code, you have to define the function properly.
<img class="emoji" role="img" draggable="false" src="https://s.w.org/images/core/emoji/14.0.0/svg/1f58a.svg" alt="🖊️" />
When you try for the auto-populating date in Excel, you need to specify the Cells clearly.📝 Takeaways from This Article
📌
Firstly, in Approach 1, we’ve shown you the use of Keyboard Shortcuts.📌
Fourthly, in Approach 4, we adopted the Fill Series Command.📌
Finally, we have shown you the process of auto-populating the date in Excel when another cell updates.Conclusion