How to change date format for Day(), Month, Year() functions

Getting help Questions
1

We are using ‘DD/MM/YY’ date format. We would like to use the same to work with Day(), Month, Year() formula factions. So that in a cell for with =Day('31/11/17') value should be evaluated as 31. Is there a way to handle this scenario?

2

Hi @amol

unfortunately, the DAY formula doesn’t work as expected yet. We need to wait for the stable version of the plugin.