Share via

Entering staggered dates in Excel

Anonymous
2022-09-23T13:23:20+00:00

Hi,

Is it possible to enter dates into a row that occur only on Monday and Wednesdays? Thanks

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2022-09-23T14:08:16+00:00

    Dear Kesai Riddick,

    Good day! Thank you for posting in Microsoft Community. We are happy to help you.

    As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

    Do you want to enter dates of a year that occurs only on Monday and Wednesday and show staggered dates?

    If yes, you may try following 2 methods:

    Method 1:

    In cell A1, enter 1/3/2022

    In cell A2, enter 1/5/2022

    In cell A3, enter formula =A1+7

    In cell A4, enter formula =A2+7

    Then in cell A3, drag the formula down, you will get result as below:

    Image

    Method 2:

    1. In cell A1, enter 1/3/2022 (the first Monday of year 2022), then go to Home tab> Fill>Series> choose Columns, Step value: 7 and Stop value: 12/31/2022, click OK. You will get all dates for Monday.

    In cell B1, enter 1/5/2022 (the first Wednesday of year 2022), go to Home tab> Fill>Series> choose Columns, Step value: 7 and Stop value: 12/31/2022, click OK. You will get all dates for Wednesday.

    Here are some screenshots for reference:

    Image

    Image

    Image

    2.Then copy all values from B column and paste them under A column, then sort A column, it will show as below.

    Image

    Hope above can help you!

    If our understanding of the scenario is not consistent with yours, feel free to point it out.

    Hope you keep safe and healthy always!

    Sincerely,

    Tina | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-26T13:46:01+00:00

    Dear Kesai Riddick,

    Good day.

    I hope everything goes well on your side. May I know if you received above replies? Do you still need help?

    Please feel free to post back if you have further concern and we will do our best to assist you.

    Stay safe and healthy always.

    Sincerely,

    Tina | Microsoft Community Moderator

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more