Forumula generated date column not sorting with filter

I am trying to sort a sheet (ART 15 report) based on a date column where the date entries are really just copied from a separate sheet (ART 15 log) using this formula: =IF('ART 15 log'!I52="","",'ART 15 log'!I52). I assume the issue is Excel is sorting the formula, not the date. Anyone know a fix for this? Ideally, I would like to sort one sheet (ART 15 log) and have that sort simultaneously be applied to the second sheet (ART 15 report). If that's not possible, is there any way to convince Excel to sort by date and not formula on my report sheet?

Thank you!

I think Excel will sort the date not the formula. Check on the default date format MM-DD-YYYY or DD-MM-YYYY so the dates entered follow the default date format. Let's solve this before going to next step.

That was my first thought, but I have the date format set for DD-MMM-YY. Have tried other formats such as mm-dd-yy with the same results. When I apply filter it only gives me the option to sort a-z and by color.

I tried both filtering and sorting a bunch of dates and in both cases it gives me the option oldest-newest so check if the column is set to DATE and all are valid dates.

That's the problem, they are not really dates, but formulas that correspond to dates on another sheet. The dates are visible on the sheet I want to sort, but this code (=IF('ART 15 log'!I52="","",'ART 15 log'!I52)) is what I suspect is being sorted instead. My question is can I sort using filter or some other method when the date is not actually typed into the sheet I'm trying to sort. I can sort the sheet on which I typed the dates. Then, the question is, if I can't sort on this sheet, is there a way to sort on the other sheet and have this sheet automatically sort? Confusing?

Not sure what, but somewhere along the line something I did fixed the problem. Thanks for the help on this.