Date & Time Functions
| AGE | Returns the age of a person given a birthday. |
| BUSDAYNEXT | Returns the date of the next business day. |
| BUSDAYPREVIOUS | Returns the date of the previous business day. |
| 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. |
| DAYSINAMONTH | Returns the number of days in a month and year. |
| DAYSINAYEAR | Returns the number of days in a year. |
| DAYSTO | Returns the number of days (or other units) to a specific event. |
| DAYSTOCHRISTMAS | Returns the number of days to Christmas. |
| TIMENOW | Returns the current time as a string (in the format "hh:mm:ss"). |
| AGE Returns the age of a person given a birthday. |
| BUSDAYNEXT Returns the date of the next business day. |
| BUSDAYPREVIOUS Returns the date of the previous business day. |
| 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. |
| DAYSINAMONTH Returns the number of days in a month and year. |
| DAYSINAYEAR Returns the number of days in a year. |
| DAYSTO Returns the number of days (or other units) to a specific event. |
| DAYSTOCHRISTMAS Returns the number of days to Christmas. |
| TIMENOW Returns the current time as a string (in the format "hh:mm:ss"). |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext