Date of birth formula

[bertrand82]

Hi,

Have a column with age. e.g. 44,56,24,35,56 etc.

Would like another column with date of birth with result 19xx-01-01

Suggestions´?

Br Bertrand

[:) Sixthsense :)]

In A1 cell
44

In B1 cell

Please Login or Register  to view this content.

Drag it down...

[dilipandey]

Hi Bertrand,


If day and month would be 1, use below formula:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>