Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA

Excel Functions & Formulas: Date & Time

7 minutes (1 section)

Course Description

When entering date and time in Excel, it is important that Excel recognizes our input appropriately and lets us subtract or add time to it.
Understanding how values of a date and time are stored in different formatting options is therefore essential.

This course covers how to:
• Enter date and time in Excel and perform calculations with it,
• Use the TODAY and NOW functions to return the current date and time,
• Change the date and time formatting,
• And, use the EOMONTH function to find the last day of a given month.

Join us, and see how you can display date and time in Excel according to your needs.

Share this course:

Related Courses

Blaise Agüera y Arcas, CTO of Technology & Society at Google, explores how to redefine what it means to be "intelligent" and navigate today’s rapidly growing AI.
1 videos
10 min
Catherine Porter, an international business leader in Silicon Valley and Japan, explores how startups can build scale beyond their home markets.
1 videos
5 min
Noriyuki Kojima, CEO & Co-Founder of Kotoba, explores how advanced speech and language AI models are solving today’s real-world communication challenges.
1 videos
5 min
Learn about allyship and how to use it to support others to create a more inclusive workplace.
4 videos
7 min
Want to make the next AltaVista? Watch Chad build a whole website just by describing it to Lovable.dev
1 videos
5 min

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months