Functions comparison of LibreOffice Calc and PlanMaker
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
PlanMaker is the spreadsheet application of SoftMaker Office. The page compares the available functions between SofMaker's PlanMaker and LibreOffice Calc.
The functions of Numbers were taken of the official documentations which can be accessed at SoftMaker.com. All functions which are not available in LibreOffice Calc are tracked in tdf#123. (ticket has to be created after most functions are analysed)
Work In Progress by Dennis Roczek (talk) 2018-10-02T17:11:52 (UTC) : Stuff with colorful cells are tested and either identical (handling) or marked with additional notes.
Feel free to update / to help me with the list - especially with the statistics functions.
Need to be done:
- update functions to latest LibreOffice which had been added in the meantime (e.g. Forecasts functions).
- Yes, I do know that the count of functions need to be updated; this works only at the end when every function was analyzed (see e.g. BINOMDIST and B).
- test all functions
Summary of comparison
Legend in this table:
- green means: Every function in this spreadsheet software is available
- yellow means: Some functions are available, but there exists other functions which are available in other spreadsheet software (e.g. EASTERSUNDAY/HOLIDAY in group Date&Time)
- red means: No function at all are available in this spreadsheet software
- todo means: need to be checked; function-name(!) itself is not available in LibreOffice and thus needs either a mapping to another function or moved to an existing function group (or a new function group should be added to this comparison)
Function Group | LibreOffice 5.0 Calc (!) | SoftMaker PlanMaker 2018 |
---|---|---|
Function Group | LibreOffice 5.0 Calc | PlanMaker 2018 |
Add-in | 50 | 41 |
Array | 10 | 9 |
Database | 12 | 12 |
Date&Time | 26 | 23 |
Duration | 0 | 0 |
Financial | 59 | 25 |
Infirmation | 21 | 18 |
Logical | 7 | 6 |
Mathematical | 81 | 61 |
Spredsheet | 21 | 16 |
Statistic | 137 | 80 |
Text | 41 | 24 |
todo | 0 | 23 |
Sum | 465 | 338 |
unique functions | tbd | XYZ: CHOISE, COUNTP, CREATEDATE, HOLIDAY, ISNUMBERP |
Comparison of functions
Functions which are identical, but have different names are sorted after LibreOffice naming. Green cells means that the functions work identical (including parameter).
Function Group | LibreOffice 5.0 Calc (!) | SoftMaker PlanMaker 2018 |
---|---|---|
Financial | ACCRINT | |
Financial | ACCRINTM | |
Mathematical | ACOS | ACOS |
Mathematical | ACOSH | ACOSH |
Mathematical | ACOT | ACOT |
Mathematical | ACOTH | ACOTH |
Spredsheet | ADDRESS | ADDRESS |
Mathematical | AGGREGATE | |
Financial | AMORDEGRC | |
Financial | AMORLINC | |
Logical | AND | AND |
Text | ARABIC | |
Spredsheet | AREAS | AREAS |
Text | ASC | |
Text | ASIN | ASIN |
Mathematical | ASINH | ASINH |
Mathematical | ATAN | ATAN |
Mathematical | ATAN2 | ATAN2 |
Mathematical | ATANH | ATANH |
Statistic | AVEDEV | AVEDEV |
Statistic | AVERAGE | AVERAGE |
Statistic | AVERAGEA | AVERAGEA |
Statistic | AVERAGEIF | AVERAGEIF |
Statistic | AVERAGEIFS | AVERAGEIFS |
Statistic | B | No^{[1]} |
Text | BAHTTEXT | |
Text | BASE | BASE |
Add-in | BESSELI | BESSELI |
Add-in | BESSELJ | BESSELJ |
Add-in | BESSELK | BESSELK |
Add-in | BESSELY | BESSELY |
Statistic | BETA.DIST | |
Statistic | BETA.INV | |
Statistic | BETADIST | BETADIST |
Statistic | BETAINV | BETAINV |
Add-in | BIN2DEC | BIN2DEC |
Add-in | BIN2HEX | BIN2HEX |
Add-in | BIN2OCT | BIN2OCT |
Statistic | BINOM.DIST | |
Statistic | BINOM.INV | |
Statistic | BINOMDIST | BINOMDIST^{[1]} |
Mathematical | BITAND | |
Mathematical | BITLSHIFT | |
Mathematical | BITOR | |
Mathematical | BITRSHIFT | |
Mathematical | BITXOR | |
Mathematical | CEILING | CEILING |
Mathematical | CEILING.MATH | |
Mathematical | CEILING.PRECISE | |
Mathematical | CEILING.XCL | |
Infirmation | CELL | CELL |
Text | CHAR | CHAR |
Statistic | CHIDIST | CHIDIST |
Statistic | CHIINV | CHIINV |
Statistic | CHISQ.DIST | |
Statistic | CHISQ.DIST.RT | |
Statistic | CHISQ.INV | |
Statistic | CHISQ.INV.RT | |
Statistic | CHISQ.TEST | |
Statistic | CHISQDIST | |
Statistic | CHISQINV | |
Statistic | CHITEST | CHITEST |
Statistic | Partial^{[2]} | CHOICE ^{[2]} |
Spredsheet | CHOOSE | CHOOSE |
Text | CLEAN^{[3]} | CLEAN^{[3]} |
Text | CODE | CODE |
Mathematical | COLOR | |
Spredsheet | COLUMN | COLUMN |
Spredsheet | COLUMNS | COLUMNS |
Mathematical | COMBIN | COMBIN |
Mathematical | COMBINA | |
Add-in | COMPLEX | COMPLEX |
Text | CONCATENATE | CONCATENATE |
Statistic | CONFIDENCE | CONFIDENCE |
Statistic | CONFIDENCE.NORM | |
Statistic | CONFIDENCE.T | |
Add-in | CONVERT | CONVERT |
Add-in | CONVERT_ADD | |
Statistic | CORREL | CORREL |
Statistic | COS | COS |
Mathematical | COSH | COSH |
Mathematical | COT | COT |
Mathematical | COTH | COTH |
Statistic | COUNT | COUNT |
Statistic | COUNTA | COUNTA |
Statistic | COUNTBLANK | COUNTBLANK |
Statistic | COUNTIF | COUNTIF |
Statistic | COUNTIFS | COUNTIFS |
Statistic | No | COUNTP^{[4]} |
Financial | COUPDAYBS | |
Financial | COUPDAYS | |
Financial | COUPDAYSNC | |
Financial | COUPNCD | |
Financial | COUPNUM | |
Financial | COUPPCD | |
Statistic | COVAR | COVAR |
Statistic | COVARIANCE.P | |
Statistic | COVARIANCE.S | |
Statistic | CRITBINOM | |
Mathematical | CSC | |
Mathematical | CSCH | |
Date&Time | No | CREATEDATE^{[5]} |
todo | CRITBINOM | |
Financial | CUMIPMT | CUMIPMT |
Financial | CUMIPMT_ADD | |
Financial | CUMPRINC | CUMPRINC |
Financial | CUMPRINC_ADD | |
Financial | No | CURRENCY |
Infirmation | CURRENT | |
Date&Time | DATE | DATE |
Date&Time | DATEDIF | DATEDIF |
Date&Time | DATEVALUE | DATEVALUE |
Database | DAVERAGE | DAVERAGE |
Date&Time | DAY | DAY |
Date&Time | DAYS | DAYS^{[6]} |
Date&Time | DAYS360 | DAYS360 |
Date&Time | DAYS^{[6]} | DAYSP^{[6]} |
Date&Time | DAYSINMONTH | DAYSPERMONTH |
Date&Time | DAYSINYEAR | DAYSPERYEAR |
Financial | DB | DB |
Database | DCOUNT | DCOUNT |
Database | DCOUNTA | DCOUNTA |
Financial | DDB | DDB |
Spredsheet | DDE | |
Add-in | DEC2BIN | DEC2BIN |
Add-in | DEC2HEX | DEC2HEX |
Add-in | DEC2OCT | DEC2OCT |
todo | DECIBEL | |
Text | DECIMAL | DECIMAL |
todo | DECIMALS | |
Mathematical | DEGREES | DEGREES |
Add-in | DELTA | DELTA |
Statistic | DEVSQ | DEVSQ |
Database | DGET | DGET |
Financial | DISC | |
Database | DMAX | DMAX |
Database | DMIN | DMIN |
Text | DOLLAR | |
Text | DOLLARDE | DOLLARDE |
Financial | DOLLARFR | DOLLARFR |
Database | DPRODUCT | DPRODUCT |
Database | DSTDEV | DSTDEV |
Database | DSTDEVP | DSTDEVP |
Database | DSUM | DSUM |
Financial | DURATION | |
Financial | DURATION_ADD | |
Database | DVAR | DVAR |
Database | DVARP | DVARP |
Date&Time | EASTERSUNDAY ^{[7]} | Partial^{[7]} |
Date&Time | EDATE | EDATE |
Financial | EFFECT | EFFECT |
Financial | EFFECTIVE | |
Text | ENCODEURL | |
Date&Time | EOMONTH | EOMONTH |
Add-in | ERF | ERF |
Statistic | ERF.PRECISE | |
Add-in | ERFC | ERFC |
Statistic | ERFC.PRECISE | |
Spredsheet | ERROR.TYPE | ERROR.TYPE |
Spredsheet | ERRORTYPE | |
Mathematical | EUROCONVERT | EUROCONVERT |
Mathematical | EVEN | EVEN |
Text | EXACT | EXACT |
Mathematical | EXP | EXP |
Statistic | EXPON.DIST | |
Statistic | EXPONDIST | EXPONDIST |
Statistic | F.DIST | |
Statistic | F.DIST.RT | |
Statistic | F.INV | |
Statistic | F.INV.RT | |
Statistic | F.TEST | |
Mathematical | FACT | FACT |
Add-in | FACTDOUBLE | FACTDOUBLE |
Logical | FALSE | FALSE |
Statistic | FDIST | FDIST |
todo | FILENAME | |
Text | FILTERXML | |
Text | FIND | FIND |
Statistic | FINV | FINV |
Statistic | FISHER | FISHER |
Statistic | FISHERINV | FISHERINV |
Text | FIXED | FIXED |
Mathematical | FLOOR | FLOOR |
Mathematical | FLOOR.MATH | |
Mathematical | FLOOR.PRECISE | |
Mathematical | FLOOR.XCL | |
Statistic | FORECAST | FORECAST |
Infirmation | FORMULA | FORMULATEXT |
Array | FREQUENCY | FREQUENCY |
Statistic | FTEST | FTEST |
Financial | FV | FV |
Financial | FVSCHEDULE | FVSCHEDULE |
Financial | GAMMA | GAMMA |
Statistic | GAMMA.DIST | |
Statistic | GAMMA.INV | |
Statistic | GAMMADIST | GAMMADIST |
Statistic | GAMMAINV | GAMMAINV |
Statistic | GAMMALN | GAMMALN |
Statistic | GAMMALN.PRECISE | |
Statistic | GAUSS | GAUSS |
Mathematical | GCD | GCD |
Mathematical | GCD_ADD | |
Statistic | GEOMEAN | GEOMEAN |
Add-in | GESTEP | GESTEP |
Spredsheet | GETPIVOTDATA | |
Array | GROWTH | GROWTH |
Statistic | HARMEAN | HARMEAN |
Add-in | HEX2BIN | HEX2BIN |
Add-in | HEX2DEC | HEX2DEC |
Add-in | HEX2OCT | HEX2OCT |
Spredsheet | HLOOKUP | HLOOKUP |
Date&Time | Partial^{[7]} | HOLIDAY^{[7]} |
Date&Time | HOUR | HOUR |
Spredsheet | HYPERLINK | HYPERLINK |
Statistic | HYPGEOM.DIST | |
Statistic | HYPGEOMDIST | HYPGEOMDIST |
Statistic | IF | IF |
Logical | IFERROR | IFERROR |
Logical | IFNA | |
Add-in | IMABS | IMABS |
Add-in | IMAGINARY | IMAGINARY |
Add-in | IMARGUMENT | IMARGUMENT |
Add-in | IMCONJUGATE | IMCONJUGATE |
Add-in | IMCOS | IMCOS |
Add-in | IMCOSH | |
Add-in | IMCOT | |
Add-in | IMCSC | |
Add-in | IMCSCH | |
Add-in | IMDIV | IMDIV |
Add-in | IMEXP | IMEXP |
Add-in | IMLN | IMLN |
Add-in | IMLOG10 | IMLOG10 |
Add-in | IMLOG2 | IMLOG2 |
todo | IMNEG | |
Add-in | IMPOWER | IMPOWER |
Add-in | IMPRODUCT | IMPRODUCT |
Add-in | IMREAL | IMREAL |
Add-in | IMSEC | |
Add-in | IMSECH | |
Add-in | IMSIN | IMSIN |
Add-in | IMSINH | |
Add-in | IMSQRT | IMSQRT |
Add-in | IMSUB | IMSUB |
Add-in | IMSUM | IMSUM |
Add-in | IMTAN | |
Spredsheet | INDEX | INDEX |
Spredsheet | INDIRECT | INDIRECT |
Infirmation | INFO | |
Mathematical | INT | INT |
Statistic | INTERCEPT | INTERCEPT |
todo | INTERSECTION | |
Financial | INTRATE | |
Financial | IPMT | IPMT |
Financial | IRR | IRR |
Infirmation | ISBLANK | ISBLANK |
Infirmation | ISERR | ISERR |
Infirmation | ISERROR | ISERROR |
Infirmation | ISEVEN | ISEVEN |
Infirmation | ISEVEN_ADD | |
Infirmation | ISFORMULA | ISFORMULA |
Date&Time | ISLEAPYEAR | |
Infirmation | ISLOGICAL | ISLOGICAL |
Infirmation | ISNA | ISNA |
Infirmation | ISNONTEXT | ISNONTEXT |
Infirmation | MBER | ISNUMBER |
Infirmation | No | ISNUMBERP |
Mathematical | ISO.CEILING | |
Infirmation | ISODD | ISODD |
Infirmation | ISODD_ADD | |
todo | ISOWEEK | |
todo | ISOWEEKNUM | |
Financial | ISPMT | ISPMT |
Infirmation | ISREF | ISREF |
Infirmation | ISTEXT | ISTEXT |
Text | JIS | |
Statistic | KURT | KURT |
Statistic | LARGE | LARGE |
todo | LASTPRINTED | |
todo | LASTSAVED | |
Mathematical | LCM | LCM |
Mathematical | LCM_ADD | |
Mathematical | LEFT | LEFT |
Text | LEFTB | |
Text | LEN | LEN |
Text | LENB | |
Array | LINEST | LINEST |
Mathematical | LN | LN |
Mathematical | LOG | LOG |
Mathematical | LOG10 | LOG10 |
Array | LOGEST | LOGEST |
Statistic | LOGINV | LOGINV |
Statistic | LOGNORM.DIST | |
Statistic | LOGNORM.INV | |
Statistic | LOGNORMDIST | LOGNORMDIST |
Spredsheet | LOOKUP | LOOKUP |
Text | LOWER | LOWER |
Spredsheet | MATCH | MATCH |
Statistic | MAX | MAX |
Statistic | MAXA | MAXA |
Array | MDETERM | MDETERM |
Financial | MDURATION | |
Statistic | MEDIAN | MEDIAN |
Statistic | MID | MID |
Text | MIDB | |
todo | MILLISECONDS | |
Statistic | MIN | MIN |
Statistic | MINA | MINA |
Date&Time | MINUTE | MINUTE |
Array | MINVERSE | MINVERSE |
Financial | MIRR | MIRR |
Array | MMULT | MMULT |
Mathematical | MOD | MOD |
Mathematical | MODE | MODE |
todo | MODP | |
Statistic | MODE.MULT | |
Statistic | MODE.SNGL | |
Date&Time | MONTH | MONTH |
Date&Time | MONTHS | |
Mathematical | MROUND | MROUND |
todo | MSOLVE | |
Mathematical | MULTINOMIAL | MULTINOMIAL |
Array | MUNIT | |
Infirmation | N | N |
Infirmation | NA | NA |
todo | NEG | |
Statistic | NEGBINOM.DIST | |
Statistic | NEGBINOMDIST | NEGBINOMDIST |
Date&Time | NETWORKDAYS | NETWORKDAYS |
Date&Time | NETWORKDAYS_ADD | |
Date&Time | NETWORKDAYS.INTL | |
Financial | NOMINAL | NOMINAL |
Financial | NOMINAL_ADD | |
Statistic | NORM.DIST | |
Statistic | NORM.INV | |
Statistic | NORM.S.DIST | |
Statistic | NORM.S.INV | |
Statistic | NORMDIST | NORMDIST |
Statistic | NORMINV | NORMINV |
Statistic | NORMSDIST | NORMSDIST |
Statistic | NORMSINV | NORMSINV |
Logical | NOT | NOT |
Date&Time | NOW | NOW |
Financial | NPER | NPER |
Financial | NPV | NPV |
Text | NUMBERVALUE | |
Add-in | OCT2BIN | OCT2BIN |
Add-in | OCT2DEC | OCT2DEC |
Add-in | OCT2HEX | OCT2HEX |
Add-in | ODD | ODD |
Financial | ODDFPRICE | |
Financial | ODDFYIELD | |
Financial | ODDLPRICE | |
Financial | ODDLYIELD | |
Spredsheet | OFFSET | OFFSET |
Financial | OPT_BARRIER | |
Financial | OPT_PROB_HIT | |
Financial | OPT_PROB_INMONEY | |
Financial | OPT_TOUCH | |
Logical | OR | OR |
todo | RRI | |
Statistic | PEARSON | PEARSON |
Statistic | PERCENTILE | PERCENTILE |
Statistic | PERCENTILE.EXC | |
Statistic | PERCENTILE.INC | |
Statistic | PERCENTRANK | PERCENTRANK |
Statistic | PERCENTRANK.EXC | |
Statistic | PERCENTRANK.INC | |
todo | PERIOD | |
Statistic | PERMUT | PERMUT |
Statistic | PERMUTATIONA | |
Statistic | PHI | PHI |
Mathematical | PI | PI |
Financial | PMT | PMT |
Statistic | POISSON | POISSON |
Statistic | POISSON.DIST | |
Mathematical | POWER | POWER |
Financial | PPMT | PPMT |
Financial | PRICE | |
Financial | PRICEDISC | |
Financial | PRICEMAT | |
Statistic | PROB | PROB |
Mathematical | PRODUCT | PRODUCT |
Text | PROPER | PROPER |
Financial | PV | PV |
Statistic | QUARTILE | QUARTILE |
Statistic | QUARTILE.EXC | |
Statistic | QUARTILE.INC | |
Mathematical | QUOTIENT | QUOTIENT |
Mathematical | RADIANS | RADIANS |
Mathematical | RAND | RAND |
Mathematical | RANDBETWEEN | RANDBETWEEN |
Mathematical | RANK | RANK |
Statistic | RANK.AVG | |
Statistic | RANK.EQ | |
Financial | RATE | RATE |
Financial | RECEIVED | |
Text | REPLACE | REPLACE |
Text | REPT | REPT |
Text | RIGHT | RIGHT |
Text | RIGHTB | |
Text | ROMAN | ROMAN |
Text | ROT13 | |
todo | ROOTN | |
Mathematical | ROUND | ROUND |
Mathematical | ROUNDDOWN | ROUNDDOWN |
Mathematical | ROUNDUP | ROUNDUP |
Spredsheet | ROW | ROW |
Spredsheet | ROWS | ROWS |
Financial | RRI | |
Statistic | RSQ | RSQ |
Text | SEARCH | SEARCH |
Text | SEC | |
Mathematical | SECH | |
Date&Time | SECOND | SECOND |
Mathematical | SERIESSUM | SERIESSUM |
Mathematical | SHEET | SHEET |
Spredsheet | SHEETS | |
todo | SHEETNAME | |
todo | SHEETNUMBER | |
Mathematical | SIGN | SIGN |
Mathematical | SIN | SIN |
Mathematical | SINH | SINH |
Statistic | SKEW | SKEW |
Statistic | SKEWP | |
Financial | SLN | SLN |
Statistic | SLOPE | SLOPE |
Statistic | SMALL | SMALL |
todo | SORTM | |
todo | SORTV | |
Mathematical | SQRT | SQRT |
Mathematical | SQRTPI | SQRTPI |
Statistic | STANDARDIZE | STANDARDIZE |
Statistic | STDEV | STDEV |
Statistic | STDEV.P | |
Statistic | STDEV.S | |
Statistic | STDEVA | STDEVA |
Statistic | STDEVP | STDEVP |
Statistic | STDEVPA | STDEVPA |
Statistic | STEYX | STEYX |
Spredsheet | STYLE | |
Text | SUBSTITUTE | SUBSTITUTE |
Mathematical | SUBTOTAL | SUBTOTAL |
Mathematical | SUM | SUM |
Mathematical | SUMIF | SUMIF |
Mathematical | SUMIFS | SUMIFS |
Mathematical | SUMPRODUCT | SUMPRODUCT |
Mathematical | SUMSQ | SUMSQ |
Mathematical | SUMX2MY2 | SUMX2MY2 |
Mathematical | SUMX2PY2 | SUMX2PY2 |
Mathematical | SUMXMY2 | SUMXMY2 |
Financial | SYD | SYD |
Financial | T | T |
Statistic | T.DIST | |
Statistic | T.DIST.2T | |
Statistic | T.DIST.RT | |
Statistic | T.INV | |
Statistic | T.INV.2T | |
Statistic | T.TEST | |
Mathematical | TAN | TAN |
Mathematical | TANH | TANH |
Financial | TBILLEQ | |
Financial | TBILLPRICE | |
Financial | TBILLYIELD | |
Statistic | TDIST | TDIST |
Text | TEXT | TEXT |
Date&Time | TIME | TIME |
todo | TIMEDIFF | |
Date&Time | TIMEVALUE | TIMEVALUE |
Statistic | TINV | TINV |
Date&Time | TODAY | TODAY |
Array | TRANSPOSE | TRANSPOSE |
Array | TREND | TREND |
Text | TRIM | TRIM |
Statistic | TRIMMEAN | TRIMMEAN |
Logical | TRUE | TRUE |
Mathematical | TRUNC | TRUNC |
Statistic | TTEST | TTEST |
Infirmation | TYPE | TYPE |
Text | UNICHAR | |
Text | UNICODE | |
Text | UPPER | UPPER |
todo | USERFIELD | |
Text | VALUE | VALUE |
Statistic | VAR | VAR |
Statistic | VAR.P | |
Statistic | VAR.S | |
Statistic | VARA | VARA |
Statistic | VARP | VARP |
Statistic | VARPA | VARPA |
Financial | VDB | |
Spredsheet | VLOOKUP | VLOOKUP |
Text | WEBSERVICE | |
Date&Time | WEEKDAY | WEEKDAY |
Date&Time | WEEKNUM | WEEKNUM |
Date&Time | WEEKNUM_ADD | |
Date&Time | WEEKS | |
Date&Time | WEEKSINYEAR | |
Statistic | WEIBULL | WEIBULL |
Statistic | WEIBULL.DIST | |
Date&Time | WORKDAY | WORKDAY |
Date&Time | WORKDAY.INTL | |
Financial | XIRR | XIRR |
Financial | XNPV | XNPV |
Logical | XOR | XOR |
Logical | YEAR | YEAR |
Date&Time | YEARFRAC | |
Date&Time | YEARS | |
Financial | YIELD | |
Financial | YIELDDISC | |
Financial | YIELDMAT | |
Statistic | Z.TEST | |
Statistic | ZTEST | ZTEST |
Sum of functions | 483 | 344 |
Notes & References
- ↑ ^{1.0} ^{1.1} B and BINOMDIST: PlanMaker 97 has added a BINOMDIST-function as "B". Excel 2013 added this function and SoftMaker readded it under the same name. The compatibility function "B" shouldn't be used as only PlanMaker can handle it.
- ↑ ^{2.0} ^{2.1} CHOISE: A workaround is to use the "IF"-function. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
- ↑ ^{3.0} ^{3.1} Calc and PlanMaker both remove characters 0-31 as specified in the OOXML specification. Calc also removes character 127. Other seldom used non-printable characters (129, 141, 143, 144, 157, or some Unicode defined ones) are not removed by both spreadsheet applications as defined in ODF. This is tracked in bug report tdf#97706.
- ↑ COUNTP: "counts only cells that contain numbers or logical values." This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
- ↑ CREATEDATE: Returns the date/time the current document was created. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
- ↑ ^{6.0} ^{6.1} ^{6.2} DAYSP: this is a compatibility function with Microsoft Excel. It is identical to DAYS, but has swapped parameters. PlanMaker is not able to map this function automatically as DAYS.
- ↑ ^{7.0} ^{7.1} ^{7.2} ^{7.3} HOLIDAY and EASTERSUNDAY: EASTERSUNDAY can be replaced in PlanMaker using HOLIDAY(TODAY(),1); 8 other different movable Christian holidays are also available in PlanMaker. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.