Forum Discussion
Anonymous
7 years agoNot applicable
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
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
- PattemManoharCommunity Champion
Anonymous Please try this..
DateOfJoin = EDATE(Test52DateAdd[DOB],Test52DateAdd[Age]*12)
- AnonymousNot applicableThank you