change due dates on my bills from Dec 2025 to Jan 2026

Cindi Ryan 0 Reputation points
2025-12-01T17:17:32.71+00:00

My bills and due dates are the same every month. I have their due dates in one column, like 12/1/25. I want to change the column of dates to show the same day, but change the month and year, like 1/1/26. How do I do this?


Moved from: Community Center | Not monitored

Microsoft 365 and Office | Excel | Other | Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Q&A Assist
    2025-12-01T17:17:44.8033333+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To change the due dates on your bills from December 2025 to January 2026, you can use a date manipulation function if you're working in a database or spreadsheet software. Here are general steps you can follow:

    1. Identify the Column: Locate the column that contains your due dates.
    2. Use a Formula: If you're using Excel or a similar program, you can create a formula to adjust the dates. For example, if your due date is in cell A1, you can use the following formula:
         =EDATE(A1, 1)
      
      This formula adds one month to the date in A1. If A1 contains 12/1/2025, the result will be 1/1/2026.
    3. Copy the Formula: Drag the fill handle down to apply the formula to the entire column of due dates.
    4. Convert to Values: If you want to keep the new dates without the formula, you can copy the new dates and paste them as values in the same column.

    If you're using a database like Microsoft Access, you can use the DateAdd() function to achieve similar results. For example:

    SELECT DateAdd("m", 1, DueDate) AS NewDueDate
    FROM Bills;
    

    This SQL query would add one month to each due date in the DueDate column of the Bills table.

    These methods will help you change your due dates accordingly.

    0 comments No comments

  2. Edward Schlobohm01 9,240 Reputation points Independent Advisor
    2025-12-01T19:13:47+00:00

    Hi,

    Thanks for reaching out and explaining what’s going on. Just to confirm, are you looking to change dates like this, turning an original due date of 12/01/25 into an updated due date of 01/01/26?

    If that’s the case, here’s a simple way to do it in Excel or any spreadsheet: use the formula

    =DATE(2026,1,DAY(A1))

    where A1 contains the original date. Copy it down the column, and it will keep the same day but change the month to January and the year to 2026.

    Let me know if this works for you or if you need more clarification.

    I’m happy to help!

    Warm regards,

    Edward

    0 comments No comments

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.