How to use Excel DAYS360 Function

Introduction DAYS360 function in Excel is a type of DATE/TIME function. It gives value of the number of days falling between two dates by considering a 360 days year. It does so by considering every month of the year to be consisting of 30 days. This function can be applied to find the number of the days from the date READ MORE

How to use Excel NOW function

Introduction NOW function in Excel is a type of DATE/TIME function. This function is used to retrieve present date with time. It is a dynamic function and updates automatically when we change a is made to the file or it is reopened. It gives result in form of serial number which can be formatted in form of date or date READ MORE

How to use Excel WORKDAY function

Introduction WORKDAY function in Excel is a type of DATE/TIME function. This function is used to retrieve a date which represents a number of working days in future or past of a specified date. This function also omits any holidays or weekends which are specified in the syntax. This function was introduced in Excel 2007 and is built in later READ MORE

How to use Excel MONTH function

Introduction        MONTH function in Excel is a type of DATE/TIME function. It used to obtain find month of a specified date. It returns a serial number in integer form (1 for Jan. up to 12 for Dec). It can be used to supply month into a cell or used with functions like DATE function as a feeder. Syntax =MONTH( Date READ MORE

How to use Excel EOMONTH function

Introduction EOMONTH function in Excel is a type of DATE/TIME function. It used to obtain last date of a month. This date can be of the present month or a month in past and future. It returns a serial number which can be formatted into a readable form. It can be used to calculate due dates falling on last date READ MORE

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 READ MORE

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 READ MORE

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 READ MORE

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 READ MORE

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. READ MORE