Spreadsheet Date and Time Formulas for Professionals

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off

One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.

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.

Syllabus

Foundations of Excel Date Intelligence

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

Mastering Advanced Date Calculations

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

Working with Time & Real-World Applications

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