How to use excel EDATE function

Introduction EDATE function in Excel is a type of DATE/TIME function. It used to obtain a date in future and past on the exact same day of a specified date. It returns a serial number which provides a date which is after or before the specified date. It is used to find expiry dates and due dates which fall on the exact same day in the month, similar to the date on which it is issued. For a date in…

Continue Reading

How to use Excel DAY Function

Introduction DAY function in Excel is a type of DATE/TIME function. It gives value of the day of month numbering between 1 and 31. This function can be applied to find the number of the day from the date present in the cell. This can also be used to extract and put the number of the day into other functions , for example in DATE function. Syntax =DAY(DATE-ARGUMENT) Arguments Date-Argument:- This is the required date in mm/dd/yyyy format. Keynotes In…

Continue Reading

How to use Excel DATEDIF Function

Introduction DATEDIF function in Excel is a type of DATE/TIME function. This function helps us in finding difference between two dates in form of month or year or day. It is bifurcated as (DATE+DIFEERENCE). We get in return a number representing time interval between the dates. Syntax =DATEDIF(START-DATE, END-DATE,UNIT) Arguments START-DATE:-  This  is the start date and should be written in default Excel date serial number formatting.END-DATE:- This is the end date and should be written in default Excel date…

Continue Reading

How to use excel DATE function

Introduction DATE function in Excel is a type of DATE/TIME function. It is used to make a date from given year, month, day which are provided individually. It can also be used as an assembler of dates which are changed from time to time based on values in the worksheet. Syntax =DATE(YEAR, MONTH,DAY) Arguments YEAR – It is a number having value between 1 and 4 digits which represents the specified year.MONTH - This is in two digits and represents…

Continue Reading

How to use TODAY function in excel

Excel version in which TODAY function can work: TODAY function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. About TODAY function in excel: This is a worksheet function. TODAY function returns the current system date in the cell.…

Continue Reading
Close Menu