I know how to do a Query that will publish the Title of my Calendar List on my homepage if the end date is today.  I am having trouble figuring out how to make a query show and publish for a spanned date range, for example Monday - Friday.  Right now I have to list each day as a separate day (not spanned).

I also need to make sure my reoccurring dates will show on my home page.

Hi Doug2015,

Base on my understanding, youd like to filter the events which in the current week.

We can add two calculated columns to help us to achieve it.

1. The first column called StartDateMonday is used to get the Monday of the Start Time week.

The formula is:

=[Start Time]-WEEKDAY([Start Time],3)

2. The Second column called EndDateSunday is used to get the Sunday of the End Time week.

The formula is:

=[End Time]-WEEKDAY([End Time],3)+6

If you want to get the date of Friday, you can change +6 to +4.

And the data types returned from these formulas are both Date and Time.

After creating them, we can add the conditions for filtering on the Edit View page such as the screenshot below:

Go back into our homepage, we will see the events of the current week.

If I miss understanding, could you provide more details about your requirement for helping me understand you clearly?

It will be much better if you can provide the screenshots of your homepage, then I can reproduce it and find the way to achieve your requirement.

Best regards,

Linda Zhang