Gestational weeks into days

[mahu2]

Help is wanted how to convert gestational weeks ( for example 38+3) into Days ( 269 Days) with a simple formula?

Thanks in advance

 

[snjpverma]

mahu2 welcome to the forum

you need to give a sample data for us to have a clear idea how your cell value looks like.

Assuming your data in weeks (38) is in cell A2, and the days (3) is in B2, then simple formula will be
=A2*7+B2

 

[mahu2]

mahu2 welcome to the forum

you need to give a sample data for us to have a clear idea how your cell value looks like.

Assuming your data in weeks (38) is in cell A2, and the days (3) is in B2, then simple formula will be
=A2*7+B2

Thanks. The problem is that the data is in the form 38+3 or 31+5 or 42+1 etc in one cell. If I could easily split it into two cells I can use your formula?

 

[steve the fish]

Try:

=IF(ISNUMBER(FIND("+",A1)),LEFT(A1,FIND("+",A1)-1)*7+MID(A1,FIND("+",A1)+1,2),A1*7)