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 |