I am making a report where i need to use a standard excel if-formula to check if a certain criteria is met.
To do this the user of the report should be able to insert a specific date in the report options. Based on this date i check if the value is higher than another date in the report. However the date inserted in the report options seem to be in a sort of text-format. I have tried to change the format of the cell but i don't seem to be able to work around this.
Any suggestions?