Difference between revisions of "Excel to Analytica Mappings/Date and Time Functions"
(→DATE) |
|||
| Line 1: | Line 1: | ||
This page shows how selected Excel Date and Time Functions map to Analytica equivalents. | This page shows how selected Excel Date and Time Functions map to Analytica equivalents. | ||
| − | = DATE = | + | = DATE(year,month,day) = |
| + | |||
| + | Analytica equivalent: | ||
| + | MakeDate(year,month,day) | ||
| + | |||
= DATEVALUE = | = DATEVALUE = | ||
= DAY = | = DAY = | ||
Revision as of 00:10, 11 January 2008
This page shows how selected Excel Date and Time Functions map to Analytica equivalents.
DATE(year,month,day)
Analytica equivalent:
MakeDate(year,month,day)
DATEVALUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WORKDAY
YEAR
YEARFRAC
Comments
Enable comment auto-refresher