Practice Date Function Online in Excel?

Watch: How to use EOMonth & EDate Function in Excel?

What is Date Function?

The DATE function returns the sequential serial number that represents a particular date. Click here to Read Full Tutorial 

What is Date Function Syntax?
				
					=DATE(YEAR,MONTH,DAY)

Practice 1: EOMonth Online Practice Excel

Click on any cell below to start practicing EOMonth Function. Check Instruction how to use the EOMonth Function.

Excel VBA Master Tool Kit
  • Click on cell C3 and type a date, like 25-11-2020.
  • Pick another empty cell where you want the result to show.
  • Type this formula: =EOMONTH(C3, 0).
  • Press Enter on your keyboard.

Practice 2: EDate Online Practice Excel

Click on any cell below to start practicing EDate Function. Check Instruction how to use the EDate Function.

  • Click on cell C3 and type a date, like 25-11-2020.
  • Click on another empty cell where you want to see the result.
  • Type this formula: =EDATE(C3, 1).
  • Press Enter on your keyboard

Watch: How to use Today & Now Function in Excel?

Practice 3: Today & Now Online Practice Excel

Click on any cell below to start practicing Today & Now Function. Check Instruction how to use the Today & Now Function.

  • Click on cell G7 and type =Now()
  • Click on cell G7 and type =Today()
  • Click on I7 and type =G7+H7
  • Click on I8 and type =G8+I8

Watch: How to use Weekday Function in Excel?

Practice 4: Weekday Online Practice Excel

Click on any cell below to start practicing Weekday Function. Check Instruction how to use the Weekday Function.

  • Click on cell A2 and type a date, like 01/15/2025
  • Click on another empty cell, like B2, where you want to see the result.
  • Type this formula: =TEXT(WEEKDAY(A2, 11), "DDDD").
  • The result will show the full name of the day for the date in A2. For example, if the date is January 15, 2025, the result will be Wednesday.

Watch: How to use Weeknum Function in Excel?

Practice 5: Weeknum Online Practice Excel

Click on any cell below to start practicing Weeknum Function. Check Instruction how to use the Weeknum Function.

  • Click on cell A2 and type a date, such as 01/15/2025.
  • Click on another empty cell, such as B2, where you want the week number to appear.
  • In the empty cell, type this formula: =WEEKNUM(A2,1)-WEEKNUM(EOMONTH(A2,-1)+1,1)
  • The result will display the week number for the date in A2, with the week starting on Sunday.

Watch: How to use Workday & Workday.Intl Function in Excel?

Practice 6: Workday Online Practice Excel

Click on any cell below to start practicing Workday  Function. Check Instruction how to use the Workday  Function.

  • Click on the cell where you want the result (e.g., F3).
  • Type =WORKDAY and open the parentheses.
  • Select the start date (e.g., click on cell B4).
  • Add a comma, then select the number of days to add (e.g., click on cell F1).
  • Add another comma, then select the holidays (e.g., drag to highlight the range B5:B8).
  • Close the parentheses and press Enter.

Practice 7: Workday.INTL Online Practice Excel

Click on any cell below to start practicing Workday.INTL Function. Check Instruction how to use the Workday.INTL Function.

  • Click on the cell where you want the result (e.g., F3).
  • Type =WORKDAY and open the parentheses.
  • Select the start date (e.g., click on cell B4).
  • Add a comma, then select the number of days to add (e.g., click on cell F1).
  • Add a Comma, then select the weekends
  • Add another comma, then select the holidays (e.g., drag to highlight the range B5:B8).
  • Close the parentheses and press Enter.

Similar Posts

How to convert CSV file to excel

How to convert CSV file to Excel (open or import)

BySumit Shrimal

This tutorial shows how to quickly change CSV files into Excel in any version, from 365 to 2007, without common problems.
There are two main ways to move a CSV file to Excel: by opening it directly or by importing it as external data. This article gives step-by-step instructions for both methods, explains their pros and cons, and highlights potential problems with tips to fix them

How to use IFERROR Function in Excel
| |

How to use IFERROR Function in Excel

BySumit Shrimal

This tutorial explains how to use the IFERROR function in Excel to catch and handle errors. It shows you how to replace errors with a blank cell, a different value, or a custom message. You’ll also learn how to use IFERROR with functions like VLOOKUP and INDEX MATCH, and how it compares to other error-checking functions like IF ISERROR and IFNA

Excel Hyperlink: how to create, change and remove
| | |

Excel Hyperlink: how to create, change and remove

BySumit Shrimal

This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel VBA Master Tool Kit