A
A
Alina Shah2020-04-23 02:55:52
Google Sheets
Alina Shah, 2020-04-23 02:55:52

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

1 answer(s)
G
galaxy, 2020-04-23
@Shah_Alina

=left(<cell with date>,4) & year(now())

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question