Question

give the syntax and example of any three date and time functions in spreadsheet​

Answer 1

Answer:

Date & Time Functions

Explanation:

Year, Month, Day. To get the year of a date, use the YEAR function. ...

Date Function. To add a number of days to a date, use the following simple formula. .

Current Date & Time. To get the current date and time, use the NOW function. ...

Hour, Minute, Second. To return the hour, use the HOUR function. ..

Time Function.