Use Of EOMONTH
StartDate
|
Plus Months
|
End Of Month
| |
05-Jan-98
|
2
|
35885
|
=EOMONTH(C4,D4)
|
05-Jan-98
|
2
|
31-Mar-98
|
=EOMONTH(C5,D5)
|
05-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.
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें