Answer the question
In order to leave comments, you need to log in
How to put the current year in the date of birth instead of the year of birth?
There is a record of the date of birth in the form 05101976.
Task: How to insert the current year instead of the last four digits (year of birth) to get a record in the adjacent cell 05102020?
Next year it is necessary that the year of birth is replaced by 2021 and there is an entry 05102021.
Is this possible at all ??
There is an example in the spreadsheet:
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question