Spreadsheet Date and Time Formulas for Professionals

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Spreadsheet Date and Time Formulas for Professionals

Instructor: EDUCBA

Included with

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

6 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

6 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Apply Excel date and time functions to automate scheduling, reporting, and deadline calculations.
Use functions such as WORKDAY, EOMONTH, DAYS360, and NETWORKDAYS for business analysis.
Calculate durations, working days, and time-based metrics accurately in real-world scenarios.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 3 modules in this course

Master Excel date and time functions to boost productivity and accuracy in real-world tasks. Learn how Excel handles dates, deadlines, and time calculations like a pro.

This course is designed to help you understand and apply Excel’s powerful date and time functions in business scenarios. You’ll begin with the fundamentals of date systems and serial numbers, then progress to essential functions such as DATE, TODAY, and WORKDAY. As you advance, you’ll explore powerful tools like EOMONTH, DAYS360, and NETWORKDAYS.INTL to handle financial calculations and working day analysis. The course also covers time functions, duration calculations, and time zone conversions for global applications. By the end of the course, you’ll be able to automate calculations, reduce errors, and confidently use Excel for reporting, scheduling, and analysis. Whether you're a student, analyst, or professional, this course equips you with practical, job-ready Excel skills.

Learn how Excel stores and processes dates using serial numbers and apply essential date functions to perform accurate calculations and data analysis.

What's included

5 videos3 assignments

5 videosTotal 32 minutes

Introduction to Master Excel Dates and Times3 minutes
Date Format in Serial Numbers6 minutes
Date System in Excel5 minutes
Date Functions11 minutes
Date Functions Continues7 minutes

3 assignmentsTotal 50 minutes

Foundations of Excel Date Intelligence30 minutes
Getting Started with Excel Dates10 minutes
Understanding Date Systems & Core Functions10 minutes

Master advanced Excel date functions such as WORKDAY, EOMONTH, DAYS360, and NETWORKDAYS.INTL to handle business scenarios, financial calculations, and working day analysis.

What's included

5 videos3 assignments

5 videosTotal 45 minutes

Function which are use in Excel11 minutes
Background function and Work Day11 minutes
Example of Eomonth Function of Excel11 minutes
Function of Days 360 in Excel6 minutes
NETWORKDAY.INTL in Excel6 minutes

3 assignmentsTotal 50 minutes

Mastering Advanced Date Calculations30 minutes
Essential Date Functions in Practice10 minutes
Advanced Date Calculations & Business Logic10 minutes

Develop expertise in Excel time functions, duration calculations, and time zone conversions to manage schedules, automate workflows, and solve real-world problems.

What's included

5 videos3 assignments

5 videosTotal 42 minutes

Time Function11 minutes
Creating Time in Excel9 minutes
Applications Tips and Tricks in Excel9 minutes
Calculating Method using Excel Formula6 minutes
Convert time to Time Zone in Excel7 minutes

3 assignmentsTotal 50 minutes

Working with Time & Real-World Applications30 minutes
Time Functions & Creation Techniques10 minutes
Practical Applications & Time Conversions10 minutes

Instructor

EDUCBA

1,615 Courses333,596 learners

Offered by

EDUCBA

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.