Excel 2016 - NOW Function - How To Add Current Date Formula in MS Office - Today Functions Formulas

In this tutorial, I show you how to use the NOW function in Microsoft Excel 2016 on Windows 10. This formula is the same on a Mac, and the steps and process should be the same. The NOW function returns the serial number of the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet in Excel 2016 or Office 365. It can also be used to calculate a value based on the current date and time, and have that value updated each time you open the workbook.

My goal is to provide you with the best learning environment possible, for all beginners of technology. Please see a list of topics below that my various playlists cover, and don't forget to like and subscribe!

Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing

Also, check out these other playlists to improve your Office 365 and Job Search Skills

Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide

Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function

Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
 
Outlook 2016
Basic Tutorial

Job Search Skills:
Values, Attitude, and Goals

Video Requests:
Download GMetrix Test Preparation Software

Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you'd like to learn in our class. So, I encourage you to make a request. I also YouTube Live Stream once a week to answer your questions!

Instructor A Morgan

[lasashssharpe]

That's the exact reason why I needed it. For this SAM homework in CIS

[Puffalupagus]

Thank you for making this video, I was losing my mind on my homework assignment.

[atemasong]

Prof. you're doing a great job, keep doing what you do. Thanks

[kimfrasier]

Can you make more MOS Exam reviews? Your 12 minute one was really helpful for my students.

[umanganand]

Thanks for the video, Professor. I'm facing an issue with this. The function is returning in the cell and if I hover my cursor over it I can see the date and time. Can you please help with this?

[cherylrajewski]

Thank you, such a simple thing and yet I was lost!

[codyyoung]

Great video! I do have one question. Is there a way to switch the military time to the regular time for this function?

[morrigangilbertson]

Your videos are super helpful! Thank you!!!

[StevenPhiTruong]

Thank you for that, I was trying to figure out what was the little simple key to enter and it was literally pressing ENTER instead of tab lol

[juliogonzalez]

Thank you I need it for my SAMS assistant 👍🏼

[treyywrath]

Very helpful Mr. Morgan -- thanks a lot.

[lisajrivera]

Hi Mr Morgan, Can you also do a video describing case problem 2, chap 3 on question 11 and 14. I am totally lost on how to place the argument, what to do in general after the tab

[Glamorous-Guinas]

hello ! Could you put the video explaining IF formula to pull in balances from one sheet to another. Thanks.

[wooderron]

hey great video, is there a way to create a different time stamp in each cell? and to create for example I hit enter and the timestamp comes up then go down to the next cell 5 mins later hit enter and then it displays the current timestamp at that help I need to create a spreadsheet for work that lets us know the time trucks are entering and leaving our facility. Any help will be greatly appreciated.

[florencekho]

Hello, Professor Adam, do you have a video showing how to put a square sign?

[ellaramirez]

can you do a video on case problem 2 chapter 3. on question 6.

[snfhatter]

is there a way to incorporate now time in a formula? Like to see how much time has elapsed from a start time until present time?

[titojoseduranceledon]

How can I insert the current date and time in a cell and leave it the same w/o changing if I insert another cell?

[MuhammadAli-jicv]

My now function does not show time, it only shows date.. Plss help