Practice EOMONTH & EDATE Function Online in Excel
Watch: How to use EOMONTH & EDATE Function in Excel?
What is EOMONTH Function?
The EOMONTH function in Excel returns the last day of a month based on a given date and a specified number of months
What is EOMONTH Function Syntax?
=EOMONTH(start_date, months)
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.
What is EDATE Function?
The EDATE function in Microsoft Excel returns a date that is a specific number of months before or after a given start date
What is EDATE Function Syntax?
=EDATE(start_date, months)
- 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
