Calculating a Date Column based off of a length column

[Anonymous]

I am trying to calculate a new column that is an expiration date column based off of a start date column and a length column. I need it to be in weeks and not months, but I am drawing a blank on how to change it. Below is what I am using, along with the current table that is calculating by months

[Daniel29195]

@Anonymous 

this is because edate add nb of months . 

i think you can do something like this : 

calculated_column =  tble_name[start date] +  6 * 7 

this way, you are considering 6  weeks, and since each 1 week have 7 days.

i think it should work . 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍