Breadcrumbs

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:

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


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


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

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:

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