Date & Time Functions in Ms-Excel

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 ()

durgaprasad

leave a comment

Create Account



Log In Your Account