Share via

how can I have the year 2025 still in the calendar while having 2026?

Dejaneyra Perez Ocasio 0 Reputation points
2025-11-24T14:17:25.3866667+00:00

I'm making a calendar and I'm having trouble keeping December as 2025. I managed to have the rest as 2026, how can I have both years on the calendar?

Microsoft 365 and Office | Excel | For education | Android

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michelle-N 16,635 Reputation points Microsoft External Staff Moderator
    2025-11-24T15:10:01.5866667+00:00

    Hi @Dejaneyra Perez Ocasio

    Thank you for reaching out to Microsoft Q&A forum.

    Based on your description, I understand that you are creating a calendar and want to include December 2025, while the rest of the calendar is set for 2026. Essentially, you want to know how to maintain both years within the same calendar view.

    Although I don't know the specific format of your calendar, I tested this in my environment using a simple table with 3 columns (Date, Month, and Year). Here is how I achieved it:

    Step 1: In the Date column (Cell A2), I entered 12/1/2025.

    Then, in Cell A3, I entered the formula =(A2+1) and dragged this formula down to the end of 2026.

    (Note: The date input format depends on your system settings. In my test environment, it is set to Month/Day/Year).User's image

    Step 2: In Cell B2 (Month), I entered the formula =TEXT([@Column1],"mmmm") and dragged it down.

    User's image

    Step 3: In Cell C2 (Year), I entered the formula =TEXT(A2,"yyyy") (or =TEXT([@Column1],"yyyy")) and dragged it down.User's image Using this method, I was able to insert December 2025 at the start, and the calendar automatically transitioned into 2026 while keeping the correct year for the 2025 dates, as shown in the image below.

    User's image

    In case you are using a different layout or method to generate your calendar, please feel free to send me a sample file via Private Message. I would be happy to test it and assist you further.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    Was this answer helpful?

  2. Dejaneyra Perez Ocasio 0 Reputation points
    2025-11-24T14:19:31.3433333+00:00

    I still don't understand, How is the formula supposed to look like?

    Was this answer helpful?

    0 comments

  3. AI answer

    2025-11-24T14:17:36.2733333+00:00

    To create a calendar that includes both December 2025 and the rest of the months in 2026, you can follow these steps:

    1. Design the Calendar Layout: Start by designing your calendar layout to accommodate two years. You can create a two-page layout or a single page that displays December 2025 alongside January to November 2026.
    2. Set the Months and Years: For the month of December, label it as December 2025. For the following months (January to November), label them as 2026. This way, you will clearly indicate that December belongs to 2025 while the others belong to 2026.
    3. Use a Calendar Tool or Software: If you are using software like Excel, you can create a table where you manually input the dates for December 2025 and then continue with the dates for 2026. Make sure to format the cells appropriately to distinguish between the two years.
    4. Visual Separation: Consider using visual elements such as borders, colors, or different fonts to separate December 2025 from the rest of the months in 2026. This will help users easily identify the transition between the two years.

    By following these steps, you can successfully create a calendar that displays both December 2025 and the subsequent months of 2026.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.