Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dateadd adding (date column + years column)

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
  • Anonymous Please try this..

     

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

2 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion

    Anonymous Please try this..

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      Thank you