EOMONTH Function (Functions in Excel)
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. |
0 comments:
Post a Comment