Excel FunctionsExcel EOMONTH Function


Used to return the last date of the month after the given number (n) of months. For example, you are given ten (10) months time to pay your first installment, and you are told that your 1st installment will be due at the last date of that month (e.g. today 25-Aug-1990). So you are due date will be June 30, 1991. 


The EDATE function syntax has the following arguments:

Start_date Required.

A date that represents the starting date.

Note: Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(1990,8,25) for the 25th day of August 1990. Problems can occur if dates are entered as text.

Months Required.

The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.

Note: If months is not an integer, it is truncated.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.