I’m trying to create a simple Excel spreadsheet which tracks three items three times per day (morning, noon, and night) over a three day period.

The table should have the following columns:

Date | Time of Day | Thing 1 | Thing 2 | Thing 3 |
---|---|---|---|---|

26/06/2023 | Morning | x | y | z |

26/06/2023 | Noon | x | y | z |

26/06/2023 | Night | x | y | z |

27/06/2023 | Morning | x | y | z |

27/06/2023 | Noon | x | y | z |

27/06/2023 | Night | x | y | z |

28/06/2023 | Morning | x | y | z |

28/06/2023 | Noon | x | y | z |

28/06/2023 | Night | x | y | z |

I am having difficulty getting Excel to autofill the dates and times. Is there a simple formula I am not aware of that could help me?