Page 53 - COMPUTER
P. 53
Date & Time Function
➢ =Now():- It Returns The Current Date And Time In A Cell.
Example:- =Now()
7/11/2016 4:29 Pm
➢ =Today() :- It Returns The Current System Date.
Example:- =Today()
11 July 2016
➢ =Month():- It Returns The Month Corresponding To Serial Date.
Example :- =Month(“6-May”) 5
=Month(7/11/16) 7
➢ Weekday() :- It Returns The Corresponding Date.
Example:- =Weekday(7/11/16) 2
➢ =Hour(Serial Time) :- It Returns The Hour Corresponding To Serial Time.
Normal Time Railway Time
1-12 Am 1-12
1-12 Pm 13-24
Example :- =Hour(“8:35 Pm”) 20hr
=Hour(“3:35 Am”) 3hr
52
