End Of Month Form.
|
|
StartDate
|
Plus Months
|
End Of Month
|
|
|
|
5-Jan-98
|
2
|
35885
|
=EOMONTH(C4,D4)
|
|
|
5-Jan-98
|
2
|
31-Mar-98
|
=EOMONTH(C5,D5)
|
|
|
5-Jan-98
|
-2
|
30-Nov-97
|
=EOMONTH(C6,D6)
|
|
|
|
|
|
|
|
What Does It Do?
|
|
|
|
|
|
This
function will show the last day of the month which is a specified number of
months
|
||||
|
before or
after a given date.
|
|
|
||
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
=EOMONTH(StartDate,Months)
|
|
|
||
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
The
result will normally be expressed as a number, this can be formatted to
represent
|
||||
|
a date by
using the Format,Cells,Number,Date command.
|
|
|||