how to filter the start and end date time to match date only?

Brass Contributor

hi 

I have a List from Sharepoint, 

bbsin_0-1702632531606.png

 

 I need to filter in Excel to display 
Event, LL, 20 pax confirmed like these that match the date  5 Jan to 6 Jan

bbsin_4-1702632795685.png

 

 

 

=FILTER(PPlan[Title],PPlan[EventStartDateTime]=F9), it show error

bbsin_3-1702632743535.png

Is there any way to display like  a merge across ?  Thanks

 



 

1 Reply

@bbsin 

Is there any way to display like  a merge across ?

 

Is there any way for you to clarify what you're working with and what your questions are?

It's all pretty vague and confusing, which is probably why, after nearly 50 views, there still were no responses.

 

For example, can you post the spreadsheet itself...posted on OneDrive or GoogleDrive, with a link here that grants access.

 

And what do you mean by display a merge across??