Date formats for Velixo Financial functions

Overview

When using dates (instead of financial periods) within your Velixo financial functions, ensure that the format used for your dates matches a date format that Excel recognizes.

Correct Example

Here we have a Velixo ACCOUNTTURNOVER function which references dates:

Excel showing an ACCOUNTTURNOVER formula referencing date cells in an Excel-recognized format, returning correct balance values


Our functions return the correct values because the dates shown are in a format which is recognized by Excel:


Close-up of date parameter cells showing a date format that Excel recognizes, confirming valid input for Velixo functions

Incorrect Example

If our date format (in this case M/D/YYYY) was not recognized...

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/R7T3UPKJXIeiJAjHV7SU_IFjQTwKKWlK8g.png


... our functions would result in an error:

Velixo function cell returning an error caused by an unrecognized date format passed as the date argument