EOMENTH Function.
The Microsoft Excel EOMONTH function will show the last day of the month which is a specified number of months before or after a given date. Or you can use EOMONTH function to calculate due dates and maturity dates that fall on the last day of the month.
Syntax : -
EOMONTH(start_date,months) The EOMONTH function syntax has the following arguments : - Start_date : - Is a date that represents the start date. Months : - Is the number of months after or before of the start date. And a positive value for months yields a future date and a negative value yields a past date in the function. |
Remarks : -
If the dates are entered as text then the function occur an error.
Dates should be entered by using the (MM/DD/YYYY) format[e.g. 12/23/2010] or DATE function, For example, use DATE(2010,12,23) for the 23rd day of Dec 2010.
If the start_date is not a valid date, Then the function EOMONTH will returns the #NUM! error value as result.
If the start_date plus months and yields an invalid date, Then EOMONTH returns the #NUM! error value as result. Click To Download File
If the dates are entered as text then the function occur an error.
Dates should be entered by using the (MM/DD/YYYY) format[e.g. 12/23/2010] or DATE function, For example, use DATE(2010,12,23) for the 23rd day of Dec 2010.
If the start_date is not a valid date, Then the function EOMONTH will returns the #NUM! error value as result.
If the start_date plus months and yields an invalid date, Then EOMONTH returns the #NUM! error value as result. Click To Download File
HOUR Function.
The Microsoft Excel HOUR function helps you to extract the hour only from a time, and the result will be shown as a normal number between 0 and 23. "0" for 12:00AM and 23 for 11:00 PM.
Syntax : -
HOUR(serial_number) The HOUR function syntax has the following arguments : - Serial_number :- Is the time that contains the hour you want to find out. Remarks : - You can enter the time as text strings within("") quotation marks [e.g. "6:45 PM"], as decimal numbers [ 0.78125] which represents 6:45 PM. |
MINUTE Function.
The Microsoft Excel MINUTE function helps you to extract the minute only from a time, and the result shown as a normal number between 0 and 59.
Syntax : -
MINUTE(serial_number) The MINUTE function syntax has the following arguments : - Serial_number :- Is the time that contains the minute you want to find out. Remarks : - You can enter the time as text strings within ("") quotation marks [e.g. "6:45 PM"], as decimal numbers [0.78125] which represents 6:45 PM. Click To Download File |
SECOND Function.
The Microsoft Excel SECOND function helps you to extract the second only from a time, and the result shown as a normal number between 0 and 59.
Syntax : -
SECOND(serial_number) The SECOND function syntax has the following arguments : - Serial_number :- Is the time that contains the second you want to find out. Remarks : - You can enter the time as text strings within("") quotation marks [e.g. "6:45:45 PM"], as decimal numbers [ 0.28177083]which represents 6:45:45 PM. |
MONTH Function.
The Microsoft Excel MONTH function helps you to extract the month only from a date, and the result will be shown as a normal number between 1 (January) to 12 (December).
[e.g 12/23/2010] or DATE function, For example, use DATE(2010,12,23) for the 23rd day of Dec,2010. Click To Download File