Excel Date functions

Excel Date functions

Vinayak Jadhav Vinayak Jadhav

Vinayak Jadhav

?? Certified Microsoft Power BI Data Analyst Associate?? Certified Microsoft Office Specialist? Non IT Professional Driving Digital Transformation ?? Generate your several Income sources

发布日期: 2024年3月24日
+ 关注

Welcome to the 3rd edition of my newsletter "Mastering Data Analytics"

Microsoft Excel provides a ton of functions to work with dates and times. Each function performs a simple operation and by combining several functions within one formula you can solve more complex and challenging tasks.

In the previous 12 parts of our Excel dates tutorial, we have studied the main Excel date functions in detail. In this final part, we are going to summarize the gained knowledge and provide links to a variety the formula examples to help you find the function best suited for calculating your dates.

The main function to calculate dates in Excel:

  • DATE function - DATE(year, month, day)?returns a serial number of a date based on the year, month and day values that you specify.

Get current date and time:

  • TODAY?- returns today's date
  • NOW?- returns the current date and time

领英推荐

Convert dates to / from text:

  • DATEVALUE?- converts a date in the text format to date format
  • TEXT?- converts a date to a text value

Retrieve dates in Excel:

  • DAY?- returns the day of the month
  • MONTH?- returns the month of a specified date
  • YEAR?- returns the year of a specified date
  • EOMONTH?- returns the last day of the month
  • WEEKDAY?- returns the day of the week
  • WEEKNUM?- returns the week number of a date

Calculate date difference:

  • DATEDIF?- returns the difference between two dates
  • EDATE?- returns a date N months before or after the start date
  • YEARFRAC?- calculates the fraction of the year between 2 dates

Calculate workdays:

  • WORKDAY?- returns a date N working days in the future or in the past
  • WORKDAY.INTL?- returns a date N weekdays from the start date with custom weekends
  • NETWORKDAYS?- returns the number of workdays between two dates
  • NETWORKDAYS.INTL?- returns the number of workdays between two dates with custom weekends


Mastering Data Analytics Mastering Data Analytics

Mastering Data Analytics

3,954 位关注者

订阅

要查看或添加评论，请登录

Vinayak Jadhav的更多文章

  • Must Know Differences for Excel:
    2024年9月1日

    Must Know Differences for Excel:

    ?? VLOOKUP vs INDEX MATCH: VLOOKUP: Searches for a value in the first column and returns a value in the same row from a…

    12 条评论
  • UNIQUE function - quick way to find unique values in Excel
    2024年7月7日

    UNIQUE function - quick way to find unique values in Excel

    The introduction of the UNIQUE function in Excel 365 has changed everything! What used to be a rocket science becomes…

    17 条评论
  • XLOOKUP or INDEX MATCH
    2024年6月30日

    XLOOKUP or INDEX MATCH

    XLOOKUP vs INDEX MATCH - syntax comparison First things first, let's break down the syntax of these formulas and…

    15 条评论
  • The Power of Dynamic Array Functions
    2024年6月16日

    The Power of Dynamic Array Functions

    In the ever-evolving landscape of data analysis and spreadsheet management, Microsoft Excel has taken a monumental leap…

    15 条评论
  • New Formulas in Excel 2023 Can increase Our Productive
    2024年6月9日

    New Formulas in Excel 2023 Can increase Our Productive

    Microsoft Excel is a powerful spreadsheet application that can be used to automate tasks, analyze data, and create…

  • Power BI interview questions and answers
    2024年6月2日

    Power BI interview questions and answers

    1. Question: What is Power BI? Answer: Power BI is a business analytics service by Microsoft that provides interactive…

    12 条评论
  • Mastering Data Cleaning and Transformation for Powerful Data Analysis
    2024年5月26日

    Mastering Data Cleaning and Transformation for Powerful Data Analysis

    In the realm of data analysis, two essential stages often go hand in hand: data cleaning and data transformation. Both…

    12 条评论
  • Essential Functions in Excel for Data Preprocessing
    2024年5月19日

    Essential Functions in Excel for Data Preprocessing

    Microsoft Excel is a great tool for preprocessing and handling structured data. Excel has functions and techniques…

    15 条评论
  • Data Visualization in Excel
    2024年5月5日

    Data Visualization in Excel

    If you want to present a data set you've collected, you can use Microsoft Excel to create spreadsheets and…

    4 条评论
  • Mastering Data Cleaning for Better Insights
    2024年4月28日

    Mastering Data Cleaning for Better Insights

    Welcome to our latest newsletter edition focusing on the vital practice of data cleaning. In today’s data-driven world,…

    5 条评论

社区洞察

其他会员也浏览了