Date as report option

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?


Please sign in to leave a comment.