I have 2 Columns like this
Where :
- Start date is inputed by user
- Finish Date is automatically filled with (Start Date 30 days)
I have used this formula in Finish Date Column
=date(year(A:A),month(A:A),day(A:A) 30)
It works well, But the formula will work if we drag the blue box any number of cells down. I want to make it automatically filled after we input the start date. I also have read that we should use some script but I don't uderstand. Any solution? Thanks!
CodePudding user response：
If you have start dates in A2:A, then array way to obtain the corresponding end date (30 days after) on each row is as follow in B2 cell.
ARRAYFORMULA(if(A2:A="","", A2:A 30))
Note: You can also put the condition like this: if(A2:A="",, A2:A 30) or just:
ARRAYFORMULA(if(LEN(A2:A),A2:A 30,))