Question

Explain any five date functione​

Answer 1

Answer:

The DATE function returns the sequential serial number that represents a particular date. ... Excel interprets the year argument according to the date system your computer is using. By default, Microsoft Excel for Windows uses the 1900 date system, which means the first date is January 1,

Explanation:

hope it will help you....☺️

Answer 2

• DATE_SUB(): Subtracts a specified time interval from a date. Syntax for DATE_SUB is same as DATE_ADD just the difference is that DATE_SUB is used to subtract a given interval of date. DATEDIFF(): Returns the number of days between two dates.Syntax: DATEDIFF(date1, date2); date1 & date2- date/time expression.