Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!
Search
Close this search box.

Business microlearning from Japan’s No1 MBA

Search
Close this search box.
Edge

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

Learn the 3 steps of hou-ren-sou, a Japanese business framework that focuses on reporting, informing, and consulting; to ensure smooth communication and effective decision-making.
4 videos
10 min
Learn how companies use Generative AI for content creation in minutes, enhancing tasks and generating social media images.
1 videos
3 min
Master the ins and outs of Japanese train etiquette with Dave as he navigates the complexities of the public transportation system.
1 videos
9 min
Discover the steps of the Japanese business card exchange, and how to show respect and professionalism with your Japanese client interactions.
4 videos
8 min
Discover how digital transformation and business ecosystems help create new values for consumers in a digitally connected world.
3 videos
18 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