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.
- 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
=WORKDAYand 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
=WORKDAYand 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.
