Category - Date & Time

AGEReturns the age of a person given a birthday.
CONVERTTIMEReturns the time converted into decimal hours, minutes or seconds.
DATEDIFFERENCEReturns the difference between two dates.
DATESERIALReturns the date serial number given a date in text format.
DAYSTOReturns the number of days (or other units) to a specific event.
DAYSTOCHRISTMASReturns the number of days to Christmas.
NUMBEROFDAYSReturns the number of days in a month and/or year.
PREVIOUSWEEKDAYReturns the date of the previous weekday.
TIMENOWReturns the current time as a string (in the format "hh:mm:ss").
AGE
Returns the age of a person given a birthday.
CONVERTTIME
Returns the time converted into decimal hours, minutes or seconds.
DATEDIFFERENCE
Returns the difference between two dates.
DATESERIAL
Returns the date serial number given a date in text format.
DAYSTO
Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS
Returns the number of days to Christmas.
NUMBEROFDAYS
Returns the number of days in a month and/or year.
PREVIOUSWEEKDAY
Returns the date of the previous weekday.
TIMENOW
Returns the current time as a string (in the format "hh:mm:ss").

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext