Date as report option

I have a report with report options where one of the inputs is a date.


This date is used in combination with the normal excel if-formula to check if a criteria is met. However it seems like the date isn't stored as a date in the sheet once the report has been run. I have tried to change the cell to "Date"-format before the report is run but it does not seem to work. After the report is run it is stored as ="dd-mm-yyyy" (Example 26-08-2020). However it does not function as a date.

Can anybody assist me?

1 comment

Please sign in to leave a comment.