| Function | Execution | Desired Result | Correct? | Notes |
| DATE | 41233 | |||
| DATEVALUE | 41233 | |||
| DAY | 20 | |||
| DAYS360 | 360 | |||
| DAYS360 | 359 | |||
| EDATE | 41263 | |||
| EOMONTH | 41274 | |||
| HOUR | 10 | |||
| MINUTE | 30 | |||
| MONTH | 11 | |||
| NOW | Not Checkable | |||
| SECOND | 54 | |||
| TIME | 0.4375 | Equal to 10:30 | ||
| TIMEVALUE | 0.4375 | Equal to 10:30 | ||
| TODAY | Not Checkable | |||
| WEEKDAY | 3 | |||
| WEEKDAY | 1 | |||
| WEEKDAY | 2 | |||
| WEEKNUM | 48 | |||
| WORKDAY | 42634 | |||
| YEAR | 2012 | |||
| YEARFRAC | 0.5 | |||
| YEARFRAC | 0.4972677595628415 | |||
| YEARFRAC | 0.5055555555555555 | |||
| YEARFRAC | 0.4986301369863014 | |||
| YEARFRAC | 0.5 |