Dateadd adding (date column + years column)

[Anonymous]

Hi everyone,

I have two columns one with Date of birth (column A) in the format - 16/07/1992 and column B with the age of participants when they entered the program eg 18, 15, 21 etc. I want to add the date of birth with the age of participants to get the beginning of program entry, which will be in a date format. E.g if participant Dob = 1/1/2000, and they are 10 years old when they enter the program the date should then be "column A (dates) + column B (years) = New date"
Thanks in advance,

P

[PattemManohar · Accepted solution]

@Anonymous Please try this..

DateOfJoin = EDATE(Test52DateAdd[DOB],Test52DateAdd[Age]*12)

[Anonymous]

Thank you