I have a speadsheet in which the first column is like
Column 1
-------------------------
Foo 1234 (22.09.21)
Baaaar 5678 (20.10.21)
And a second column contains dates only and is generated from the first one by the =REGEX()
function:
=REGEX($A2,"^.+\(([[:digit:]|\.]+)\)$","$1")
Column 2
-------------------------
22.09.21
20.10.21
And I need a third column, which should contain values generated as date_in_column_2 + 14_days
.
What I have I tried is =B2+14
in C2, but if the date in B2 is generated by a regex instead of typed by hand, =B2+14
in C2 gives me an error.
How should I fix it? Thanks.
Also, there is another question. I know it is against Q&A rules and I can ask it as a separate question, but in case it is really easy, could one show how to perform date_in_column_2 + 14_days
calculation for working days only, i.e. without Saturdays and Sundays?