Excel: repeat date range across multiple rows in chornological order

Question

Hi,

i hope I can explain this ok.

I am creating a room booking spreadsheet for office users with minimal excel skills.

More indepth details are on individual tabs with summaries on the main tab.

I am displaying the times in 15minute slots allowing for room booking in and out and looking to repeat the date next to it in chronological order.

Given the amount of reoccuring dates, I cannot use the drag fill, so wondering if there is another way to use a formula or function to have the dates repeating without me having to fill every cell manually. Looking to have the times repeat as well alongside the dates.  the date range I am looking for is going into the 2021 financial year.

I hope this makes sense. Thanks!!

Answer 1

Thank you, I will take a read. I am not familiar with DAX so will check it out. Thank you.