EOMONTH Function calculates the last day of the month after adding a specific number of months to a given date. The result is returned as a serial date.
This function is an inbuilt function in Excel and is categorized as a Date/Time Function. As a worksheet function, the EOMONTH function can be entered as part of a formula.
=EOMONTH (start_date, months)
start_date: A date that represents the start date in a valid Excel serial number format.
months: The number of months before or after start_date.
I have created the infographics for the EOMONTH Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
If you receive a #NAME? error while using the EOMONTH function, install and load the Analysis ToolPak add-in. To activate Analysis ToolPak follow the below steps:
Note: While giving the start_date to the function, you must enter either a reference to a cell containing a date or a date returned from another function or formula.
If you input the date arguments as text, the interpretation of the date might differ. It is dependent on the date system and date interpretation settings of your computer.
To learn other function like NETWORKDAYS, EDATE and ISTEXT Functions, please click on the name of the function.
Additionally, you can download other accounting templates like Cash Book with VAT, Sales Revenue Analysis Template and Trial Balance from here.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…
Every business has to register for VAT with HM Revenue and Customs if their VAT…
We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…
We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…
We have created a simple and easy UK VAT Sales Register Excel Template with predefined…
We have created a ready to use UK VAT Progress Billing Invoice template in excel…