Now (): -It returns the date and time
value.
Syntax: - =Now()
Ex: - =Now()
Datevalue: -This function converts a date in
text to a date in serial number.
Syntax: - =Datevalue(“dateâ€)
Ex: - =Datevalue(“04/11/2011â€)
Day: -This function return the day of a
date.
Syntax: - =Day(“dateâ€)
Ex: - =Day(“04/11/2011â€)
Month: -This function return the month of
a date.
Syntax:- =Month(“dateâ€)
Ex: - =Month(“04/11/2011â€)
Year: -This function return the year of
a date.
Syntax: - =Year(“dateâ€)
Ex: - =Year(“04/11/2011â€)
Weekday: -This function returns on integer
from 1 to Sunday to 7 for Saturday.
Syntax: - =Weekday(“dateâ€)
Ex: - =Weekday(“04/11/2011â€)
Days360: -This function calculates the
number of days between two dates.
Syntax: - =Days360(“date1â€,â€date2â€)
Ex: - =Days360(“01/15/1990â€,â€04/11/2011â€)