Share via

How to lock events (think bills and payments) to dates in an excel calendar?

Teniecha Cowart 0 Reputation points
2025-01-12T21:59:44.0233333+00:00

Hi there, I have a calendar in excel. Currently, if I copy the sheet and change the date in the first cell (think 1/1/2024 to 2/1/2024) the new month will populate with the dates and days correctly aligned. I'l like to lock my text to dpecific dates on the calendar so that, for example, I can have my car note due date move to the correct day/date in the new month. Not just the cell it was in the preveious month. Can anyone help or make suggestions please?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,078 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,147 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 3,236 Reputation points
    2025-01-13T08:11:22.0033333+00:00

    You can build a lookup table in an unused area of the worksheet or in a separate worksheet. Column 1 of the table would contain the days of the month (in order) and column 2 would contain the event(s) that should occur on that day. For sake of demonstration, put this table is Q1:R31

    If cells A1:A31 of your calendar contain the dates of the month then cell B1 would contain =VLOOKUP(DAY(A1),Q1:R31,2,FALSE) and you copy this formula to B2:B31.

    You many need some extra processing for events that occur after the 28th.

    However, since the 10th of the month will always fall in cell A10, the event for the 10th will always fall in B10. So I wonder why you need this at all.

    0 comments

Your answer

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