Date & Time Functions in Ms-Excel

In this video we can discuss about Time & Date Functions in our Excel Sheet.

Short Notes of Above Topic:-

1. DATE ():-

It returns given date.

Syntax:-

=DATE (yy,mm,dd)

2. TODAY ():- 

We can use this one to returns the today's date.

Syntax:-

=TODAY ()

3. TIME ():-

It returns the number that represents a particular time.

Syntax:- =TIME(hr,min,sec)

4. NOW ():- 

We can use this one to returns the today's date and time.

Syntax:-

=NOW ()