Excel to Analytica Mappings/Date and Time Functions

< Excel to Analytica Mappings

Revision as of 00:10, 11 January 2008 by Lchrisman (talk | contribs) (→‎DATE)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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