Using a formula with parameters that are calculated in RIGHT/LEFT function

Corentin Dal Farra

Hello everyone,

I have a problem with one formula and I do not know how to correct it :

I have a sheet with four columns :

• First one : the date in text format Year-Week number
• Second column : extract year
• Third column : extract week number
• Fourth colmun : calculate an automatic date

I would like to use a formula that automatically calculate the date when I put a value in the first column. Currently I have to put manually year and week number..

When I try to do a LEFT function to get only the year for example, the formula in the fourth column do not work anymore.

Do you know how to bypass this problem ?

Thank you, have a great day,

Corentin

Nicolás Trejo

Hello, @Corentin Dal Farra

Maybe it is not working because you need to convert the texts into numbers using the VALUE() function. It would be something like this:

Debut Livraison Annee: =VALUE(LEFT([Semaine RBàL Livré]@row, 4))

Debut Livraison Semaine: =VALUE(RIGHT([Semaine RBàL Livré]@row, 2))

Beware if you have some input like 2020-3 (week with just one character).

Regards!

Nicolás Trejo

Hello, @Corentin Dal Farra

Maybe it is not working because you need to convert the texts into numbers using the VALUE() function. It would be something like this:

Debut Livraison Annee: =VALUE(LEFT([Semaine RBàL Livré]@row, 4))

Debut Livraison Semaine: =VALUE(RIGHT([Semaine RBàL Livré]@row, 2))

Beware if you have some input like 2020-3 (week with just one character).

Regards!

Corentin Dal Farra

@Nicolás Trejo

Thank you very much for your answer !

I have spent so much time on this without finding a solution..

Again thank you !

Corentin