Issue using filter function with Sunday

[Dazzybeeguy]

Hi - I have this formula

=IF(E3>0,FILTER('Duty Officer Rota'!D3:E892,'Duty Officer Rota'!B3:B892='Duty Officer Rota'!H2,'Duty Officer Rota'!E3:F892),"")

Column D contains dates

For some strange reason despite formatting being the same in the filtered list the 1st couple of Sundays come back as Sunday and all the other Sundays and other days formats as desired i.e. ddd-dd-mmm-yy i.e. Sun-22-Dec-24

 

[StephenCrump]

When you say "come back as Sunday", do you mean a date formatted as "dddd", in which case it's a formatting issue?

Or the value "Sunday", which means that your data in 'Duty Officer Rota'!D3:E892 contains these values?

(It's also not clear why you have specified if_empty as 'Duty Officer Rota'!E3:F892)?