In this article, we will learn how to enter dates quickly in Microsoft Excel 2010.
With dates formula we can count dates based on if the condition meets or not, we can count days between dates.
In order to enter date of a current month in a cell where excel will let you enter only a number in a cell & the formula will enter the year & month itself, the functions we can use are DATE, YEAR, MONTH, TODAY.
DATE: Returns the number that represents the date in Microsoft Excel date-time code.
year: The year argument can include one to four digits. By default, Excel uses the 1900 date system.
month: The second argument, representing the month of the year from 1 to 12 (January to December)
day: The third argument, representing the day of the month from 1 to 31.
YEAR: Returns the year of a date, an integer in the range 1900 – 9999
serial_number: The date of the year you want to find.
MONTH: This function returns the month (January to December as 1 to 12) of a date.
serial_number: It refers to the date of the month that you are trying to find.
TODAY: Returns the current date formatted as a date
TODAY function does not have any argument.
Let us take an example:
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.