Date and Text Functions in Excel
I have tried to covered the following Excel Functions in this video
DATE : Returns the sequential serial number that represents a particular date. If the cell format was General before the function was entered, the result is formatted as a date.
DAY : Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
Syntax
DAY(serial_number)
MONTH : Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Syntax
MONTH(serial_number)
YEAR : Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.
Syntax
YEAR(serial_number)
EDATE : Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Syntax
EDATE(start_date,months)
EOMONTH : Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
Syntax
EOMONTH(start_date,months)
TODAY : Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations. If the cell format was General before the function was entered, the result is formatted as a date.
Syntax
TODAY( )
~-~~-~~~-~~-~
Please watch: "How to prepare Financial Statements in excel in hindi"
• How to prepare Financial Statements in exc...
~-~~-~~~-~~-~