MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Make Column C Automatically Input a Date 28 Days After Column A?

When I put a date in column A I would like Column C to automatically input a date 28 days later. Is this possible? Thanks.

I am trying not to have to go into my calendar app and count 28 days later to input a date in column C when I put my date in column A.
—–
Trevor

Comments: 5 Responses to “How Do I Make Column C Automatically Input a Date 28 Days After Column A?”

    3 years ago

    Just add 28.
    So if A2 contains 6/1/2022, then the formula in C2 should be =A2+28.
    This will add 28 (days) to the value in A2 and show that value in C2.
    Put that formula into all non-header cells in C and it will happen automatically. As you put values in cells in A, the date + 28 will appear in C.

    Trevor
    3 years ago

    Ok, now how do I get the number 28 in column C to not be there. It goes away when I put a date in column A, but before I put a date it’s just 28.

    3 years ago

    Trevor: So you have rows where A is blank? Ideally you wouldn't have any blank rows. Just add rows as needed, but have no blank ones. Is there a reason you need blank rows?

    Chris
    3 years ago

    @Trevor you can do it when you combine it with the Formula "IF"
    In Column C try this:
    =IF(A2="","",A2+28)

    Trevor
    3 years ago

    Thank you

Comments Closed.