DATEADD not giving me the dates

[guanel1]

I am needing to create a visit window report to show the expected visit windows for visits based on the procedure date. 

here is what i have uploaded as an example:

I am trying to have the [Visit window Start] column display to show the [Procedure] date plus 5 days. (see formula bar for what i used).

So for example, the first procedure date is listed as 01-MAR-2020 so the date that should be calculated is 06-MAR-2020. But nothing shows up. 

What am I doing incorrectly?

[amitchandak]

@guanel1 , date add need continuous dates , Simply add +5 for days

Visit Window Start = Table3[Procedure] +5

Also, refer: https://www.youtube.com/watch?v=YWo-ZpKM6gU

[guanel1]

Thank you, this is works when there is always a date listed in the procedure column. However, if it is blank, what formula should i use to have it give me a blank answer? 

[camargos88 · Accepted solution]

@guanel1 ,

You need a table with continuos date, create a date table and relate them, use this code on your column:

Column = DATEADD(Data[Date], 5, DAY)