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
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.
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.
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?
@Trevor you can do it when you combine it with the Formula "IF"
In Column C try this:
=IF(A2="","",A2+28)
Thank you