Putting 1 in row after a specified number of rows.

[iali]

Hi,

Need help to automate and make this dynamic based on the input.

I have a number of projects with duration in days to complete the project as input. I want to be able to put 1 in the cell the day project finishes. For example (as shown in the attached) if project 1 starts on Dec 1 and has a duration of 20 days, therefore, I want to put 1 beside 20 Dec. Project 2 will then start on Dec 21 and if that has a duration of 30 days, I want to put 1 beside 19 Jan, and so on.......

Any help would be much appreciated.

Regards
Data Test.xlsx

[FDibbins]

hi and welcome to the forum

not sure if this is what you want, give it a try and let me know.

in E2, copied down, use this
=$C$13+D2

then (i put this in E13, copied down), use this...
=IF(ISERROR(VLOOKUP(C13,$E$2:$E$7,1,FALSE)),"",1)

[Teethless mama]

See the attached

[kvsrinivasamurthy]

Pl see attached file.Formula is available in D column.

[iali]

[Solved]

Thank you for the help. All the solutions posted work. Really appreciate your help on this.

[Teethless mama]

You're Welcome!