Date and time

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 …

How to use Excel DATEDIF Function 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 …

How to use excel DATE function Read More »